<?php
class ModelNewsInstall extends Model {
	public function checkInstall(){		
		/*Check Database*/ 	
		$this->checkBlogCategory();
		$this->checkBlogArticle();
		$this->checkAuthor();
		$this->checkDownload();
		$this->checkShoutbox();
		$this->checkPolls();	
		/*checkField - Create Field if not exist*/ 
		$this->checkField('news_article','approved','tinyint(1) NOT NULL DEFAULT 0');
		$this->checkField('news_article','reference_url','varchar(255) COLLATE utf8_bin DEFAULT NULL');
		$this->checkField('news_article','reference_title','varchar(255) COLLATE utf8_bin DEFAULT NULL');
		$this->checkField('news_article','new_category','varchar(255) NOT NULL');
		$this->checkField('news_article','poll_id','int(11) NOT NULL');
		$this->checkField('news_article_description','sub_description','text COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','store_id','int(11) NOT NULL DEFAULT 0');
		$this->checkField('news_author','sort_order','int(11) NOT NULL DEFAULT 0');
		$this->checkField('news_author','firstname','varchar(32) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','lastname','varchar(32) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','author_description','longtext COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','email','varchar(96) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','telephone','varchar(32) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','website','varchar(128) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','password','varchar(40) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','salt','varchar(9) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','address','varchar(128) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','city','varchar(128) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','country_id','int(11) NOT NULL DEFAULT 0');
		$this->checkField('news_author','zone_id','int(11) NOT NULL DEFAULT 0');
		$this->checkField('news_author','ip','varchar(40) COLLATE utf8_bin NOT NULL DEFAULT 0');
		$this->checkField('news_author','status','tinyint(1) NOT NULL');
		$this->checkField('news_author','approved','tinyint(1) NOT NULL');
		$this->checkField('news_author','token','varchar(255) COLLATE utf8_bin NOT NULL');
		$this->checkField('news_author','newsletter','tinyint(1) NOT NULL DEFAULT 0');
		$this->checkField('news_article_image','language_id','int(11) NOT NULL');
		$this->checkField('news_article_image','image_description','varchar(255) COLLATE utf8_bin');
		$this->checkField('category','related_id','int(11) NOT NULL');
		
		if (!$this->config->get('config_news_installed')&&$this->user->hasPermission('modify', 'module/article_all_settings')) {
			/*add Blog Layout*/ 			
			$layout_route = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "layout_route WHERE route = 'news/'");		
			if ($layout_route->row['total']==0) {				
				$this->db->query("INSERT INTO " . DB_PREFIX . "layout SET name = 'Blog'");		
				$layout_id = $this->db->getLastId();
				$this->db->query("INSERT INTO " . DB_PREFIX . "layout_route SET 
									layout_id = '" . (int)$layout_id . "', 
									store_id = '" . (int)$this->config->get('config_store_id') . "',
									route = 'news/'");	
			}
	/*add Config*/
	$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_all_settings'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_news_installed', value = '1'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_account_id', value = ''");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_news_canonical', value = '".HTTP_CATALOG."'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_upload_allowed', value = 'jpeg,jpg,png'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_username_not_allowed', value = 'admin,root'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_register_status', value = '1'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_approved', value = '0'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_article_status', value = '0'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_article_approved', value = '0'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_category', value = '0'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_display_refer', value = '1'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_author_permission', value = '1'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_sort', value = 'p.date_added'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_order', value = 'DESC'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_image_column_width', value = '150'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_image_column_height', value = '112'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_catalog_image_width', value = '150'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_catalog_image_height', value = '112'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_description_limit', value = '255'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_article_limit', value = '2'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_children_limit', value = '2'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_catalog_position', value = 'content_top'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_related_catalog_status', value = '1'");
	
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_related_height', value = '150'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_thumb_height', value = '300'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_related_width', value = '200'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_additional_height', value = '75'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_additional_width', value = '100'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_popup_height', value = '600'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_popup_width', value = '800'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_thumb_width', value = '400'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_image_article_height', value = '150'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_image_article_width', value = '200'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_category_height', value = '150'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_category_width', value = '200'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'article_description_limit', value = '255'");
	
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_login_to_download', value = '0'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_news_upload_allowed', value = 'jpg,png,txt,zip,rar,xls,xlsx,doc,docx'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_article_date_format', value = 'Y/m/d'");

	
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_comment_status', value = '1'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_comment_approved', value = '1'");
			
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_category'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_list'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_by_type'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_author'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_free_download'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_search'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_poll'");
			/*add Permission*/ 
			$this->load->model('user/user_group');	
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/category');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/category');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/article');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/article');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/author');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/author');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/poll');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/poll');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/shortcut_module');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/shortcut_module');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/shortcut_route');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/shortcut_route');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/author_blacklist');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/author_blacklist');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/download');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/download');
			
			$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'news/comment');
			$this->model_user_user_group->addPermission($this->user->getId(), 'modify', 'news/comment');								
			$this->checkModule('module','article_category');
			$this->checkModule('module','article_list');
			$this->checkModule('module','article_by_type');
			$this->checkModule('module','article_author');
			$this->checkModule('module','article_free_download');
			$this->checkModule('module','article_search');
			$this->checkModule('module','article_slideshow');
			$this->checkModule('module','article_poll');
			$this->checkModule('module','article_shoutbox');
		}			
	}
	/*check Install Blog Module*/ 
	public function checkModule($route,$code) {
      	$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "extension WHERE code = '" .$this->db->escape($code). "'");		
		if ($query->row['total']==0) {		
			$this->load->model('setting/extension');			
			$this->model_setting_extension->install($route,$code);
			$this->model_user_user_group->addPermission($this->user->getId(),'access', $route.'/'.$code);
			$this->model_user_user_group->addPermission($this->user->getId(),'modify', $route.'/'.$code);
		}
	}	
	
	/*Create Field if not exist*/ 
	public function checkField($table,$field,$type) {	
		$exists = false;
		$query=$this->db->query("SHOW columns FROM `".DB_PREFIX.$table."`");	
		foreach($query->rows as $column){
			if($column['Field'] == $field){
			 $exists=true;
			}
		}
		if(!$exists){
		$this->db->query("ALTER TABLE ".DB_PREFIX.$table." ADD ".$this->db->escape($field)." ".$this->db->escape($type));
		}
	}
	/*Create Article Database*/ 
	public function checkBlogArticle() {
		$news_article = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article` (
			  `article_id` int(11) NOT NULL AUTO_INCREMENT,
			  `model` varchar(64) COLLATE utf8_bin NOT NULL,
			  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
			  `author_id` int(11) NOT NULL,
			  `poll_id` int(11) NOT NULL,
			  `sort_order` int(11) NOT NULL DEFAULT '0',
			  `status` tinyint(1) NOT NULL DEFAULT '0',
			  `date_added` datetime NOT NULL,
			  `date_modified` datetime NOT NULL,
			  `new_category` varchar(255) COLLATE utf8_bin NOT NULL,
			  `reference_url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
			  `reference_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
			  `viewed` int(5) NOT NULL DEFAULT '0',
			  PRIMARY KEY (`article_id`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;";		
			$news_article_description = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_description` (
			  `article_id` int(11) NOT NULL AUTO_INCREMENT,
			  `language_id` int(11) NOT NULL,
			  `name` varchar(255) COLLATE utf8_bin NOT NULL,
			  `description` longtext COLLATE utf8_bin NOT NULL,
			  `meta_description` varchar(255) COLLATE utf8_bin NOT NULL,
			  `meta_keyword` varchar(255) COLLATE utf8_bin NOT NULL,
			  `tag` text COLLATE utf8_bin NOT NULL,
			  `h1` varchar(255) COLLATE utf8_bin NOT NULL,
			  `h2` varchar(255) COLLATE utf8_bin NOT NULL,
			  `h3` varchar(255) COLLATE utf8_bin NOT NULL,
			  `h3_p` text COLLATE utf8_bin NOT NULL,
			  `h4` varchar(255) COLLATE utf8_bin NOT NULL,
			  `h4_p` text COLLATE utf8_bin NOT NULL,
			  `h5` varchar(255) COLLATE utf8_bin NOT NULL,
			  `h6` varchar(255) COLLATE utf8_bin NOT NULL,
			  `content_l1` varchar(255) COLLATE utf8_bin NOT NULL,
			  `content_l2` varchar(255) COLLATE utf8_bin NOT NULL,
			  `content_l3` text COLLATE utf8_bin NOT NULL,
			  `content_l4` text COLLATE utf8_bin NOT NULL,
			  `content_r1` varchar(255) COLLATE utf8_bin NOT NULL,
			  `content_r2` varchar(255) COLLATE utf8_bin NOT NULL,
			  `content_r3` text COLLATE utf8_bin NOT NULL,
			  `content_r4` text COLLATE utf8_bin NOT NULL,
			  PRIMARY KEY (`article_id`,`language_id`),
			  KEY `name` (`name`),
			  FULLTEXT KEY `description` (`description`),
			  FULLTEXT KEY `tag` (`tag`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;";		
		
		$news_article_image = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_image` (
			  `article_image_id` int(11) NOT NULL AUTO_INCREMENT,
			  `article_id` int(11) NOT NULL,
			  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
			  `sort_order` int(3) NOT NULL DEFAULT '0',
			  `language_id` int(11) NOT NULL,
			  `image_description` varchar(255) COLLATE utf8_bin,
			  PRIMARY KEY (`article_image_id`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1;";
		$news_related_article = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_related_article` (
			  `article_id` int(11) NOT NULL,
			  `article_related_id` int(11) NOT NULL,
			  PRIMARY KEY (`article_id`,`article_related_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$news_related_product = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_related_product` (
			  `article_id` int(11) NOT NULL,
			  `product_related_id` int(11) NOT NULL,
			  PRIMARY KEY (`article_id`,`product_related_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$news_article_to_category = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_to_category` (
			  `article_id` int(11) NOT NULL,
			  `article_category_id` int(11) NOT NULL,
			  PRIMARY KEY (`article_id`,`article_category_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$news_article_to_download = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_to_download` (
			  `article_id` int(11) NOT NULL,
			  `download_id` int(11) NOT NULL,
			  PRIMARY KEY (`article_id`,`download_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$news_article_to_layout = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_to_layout` (
			  `article_id` int(11) NOT NULL,
			  `store_id` int(11) NOT NULL,

			  `layout_id` int(11) NOT NULL,
			  PRIMARY KEY (`article_id`,`store_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";			
		$news_article_to_store = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_article_to_store` (
		  `article_id` int(11) NOT NULL,
		  `store_id` int(11) NOT NULL DEFAULT '0',
		  PRIMARY KEY (`article_id`,`store_id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";	
		
		$news_comment = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_comment` (
			  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
			  `article_id` int(11) NOT NULL,
			  `customer_id` int(11) NOT NULL,
			  `author` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
			  `text` text COLLATE utf8_bin NOT NULL,
			  `rating` int(1) NOT NULL,
			  `status` tinyint(1) NOT NULL,
			  `date_added` datetime NOT NULL,
			  `date_modified` datetime NOT NULL,
			  PRIMARY KEY (`comment_id`),
			  KEY `article_id` (`article_id`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1;";	
		$this->db->query($news_article);
		$this->db->query($news_article_description);
		$this->db->query($news_article_image);
		$this->db->query($news_related_article);
		$this->db->query($news_related_product);
		$this->db->query($news_article_to_category);
		$this->db->query($news_article_to_download);
		$this->db->query($news_article_to_layout);
		$this->db->query($news_article_to_store);		
		$this->db->query($news_comment);		
	}
	
	/*Create Blog Category Database*/ 
	public function checkBlogCategory() {
		$news_category = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_category` (
			  `article_category_id` int(11) NOT NULL AUTO_INCREMENT,`image` varchar(255) COLLATE utf8_bin DEFAULT NULL,`parent_id` int(11) NOT NULL DEFAULT '0',`top` tinyint(1) NOT NULL,`column` int(3) NOT NULL,`sort_order` int(3) NOT NULL DEFAULT '0',`status` tinyint(1) NOT NULL,`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`article_category_id`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1;";
		$news_category_description = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_category_description` (
			  `article_category_id` int(11) NOT NULL,`language_id` int(11) NOT NULL,`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',`description` text COLLATE utf8_bin NOT NULL,`meta_description` varchar(255) COLLATE utf8_bin NOT NULL,`meta_keyword` varchar(255) COLLATE utf8_bin NOT NULL,PRIMARY KEY (`article_category_id`,`language_id`),KEY `name` (`name`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";			
		$news_category_to_layout = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_category_to_layout` (
			  `article_category_id` int(11) NOT NULL,`store_id` int(11) NOT NULL,`layout_id` int(11) NOT NULL,PRIMARY KEY (`article_category_id`,`store_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";	
		$news_category_to_store = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_category_to_store` (
			  `article_category_id` int(11) NOT NULL,`store_id` int(11) NOT NULL,PRIMARY KEY (`article_category_id`,`store_id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";	
		
		$this->db->query($news_category);
		$this->db->query($news_category_description);	
		$this->db->query($news_category_to_layout);	
		$this->db->query($news_category_to_store);	
		
	}
	/*Create Author Database*/ 
	public function checkAuthor(){		
		$news_author = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_author` (
		  `author_id` int(11) NOT NULL AUTO_INCREMENT,
		  `author` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
		  `store_id` int(11) NOT NULL DEFAULT '0',
		  `firstname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `lastname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
			`author_description` longtext COLLATE utf8_bin NOT NULL,
		  `email` varchar(96) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `telephone` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `website` varchar(128) COLLATE utf8_bin NOT NULL,
		  `password` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `salt` varchar(9) COLLATE utf8_bin NOT NULL DEFAULT '',
		  `address` varchar(128) COLLATE utf8_bin NOT NULL,
		  `city` varchar(128) COLLATE utf8_bin NOT NULL,
		  `country_id` int(11) NOT NULL DEFAULT '0',
		  `zone_id` int(11) NOT NULL DEFAULT '0',
		  `ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0',
		  `status` tinyint(1) NOT NULL,
		  `approved` tinyint(1) NOT NULL,
		  `token` varchar(255) COLLATE utf8_bin NOT NULL,
		  `date_added` datetime NOT NULL,
		  `newsletter` tinyint(1) NOT NULL DEFAULT '0',
		`sort_order` int(11) NOT NULL DEFAULT '0',
		  PRIMARY KEY (`author_id`)
		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1;";	
		$news_author_ip = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_author_ip` (
		  `author_ip_id` int(11) NOT NULL AUTO_INCREMENT,
		  `author_id` int(11) NOT NULL,
		  `ip` varchar(40) COLLATE utf8_bin NOT NULL,
		  `date_added` datetime NOT NULL,
		  PRIMARY KEY (`author_ip_id`),
		  KEY `ip` (`ip`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;";
		$news_author_ip_blacklist = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_author_ip_blacklist` (
		  `author_ip_blacklist_id` int(11) NOT NULL AUTO_INCREMENT,
		  `ip` varchar(40) COLLATE utf8_bin NOT NULL,
		  PRIMARY KEY (`author_ip_blacklist_id`),
		  KEY `ip` (`ip`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;";
		
		$this->db->query($news_author);
		$this->db->query($news_author_ip);
		$this->db->query($news_author_ip_blacklist);
	}
	/*Create Download Database*/ 
	public function checkDownload(){		
		$news_download = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_download` (
			  `download_id` int(11) NOT NULL AUTO_INCREMENT,
			  `filename` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
			  `mask` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
			  `auth_key` varchar(64) COLLATE utf8_bin NOT NULL,
			  `remaining` int(11) NOT NULL DEFAULT '0',
			  `date_added` datetime NOT NULL,
			  PRIMARY KEY (`download_id`)
			) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;";	
		$news_download_description = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_download_description` (
				  `download_id` int(11) NOT NULL,
				  `language_id` int(11) NOT NULL,
				  `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
				  PRIMARY KEY (`download_id`,`language_id`)
				) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";	
		$this->db->query($news_download);	
		$this->db->query($news_download_description);	
	}
	/*Create Shoutbox Database*/ 
	public function checkShoutbox(){		
		$create_shoutbox = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."shoutbox` (
		`shout_id` int(11) NOT NULL auto_increment, 
		`customer_id` int(11) NOT NULL, 
		`author` varchar(64) NOT NULL, 
		`message` TEXT NOT NULL, 
		`status` int(1) NOT NULL default '1',  
		`date_added` datetime NOT NULL default '0000-00-00 00:00:00', 
		`date_modified` datetime NOT NULL default '0000-00-00 00:00:00', 
		PRIMARY KEY  (`shout_id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";	
		$this->db->query($create_shoutbox);		
	}
	/*Create Poll Database*/ 
	public function checkPolls(){
		$create_poll = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_poll` (
		`poll_id` int(11) NOT NULL auto_increment, 
		`date_added` datetime NOT NULL default '0000-00-00 00:00:00', 
		PRIMARY KEY  (`poll_id`)) 
		ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$this->db->query($create_poll);
		$create_poll_descriptions = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_poll_description` (
		`poll_id` int(11) NOT NULL, 
		`language_id` int(11) NOT NULL, 
		`question` varchar(255) collate utf8_bin NOT NULL, 
		`answer_1` varchar(255) collate utf8_bin NOT NULL,
		`answer_2` varchar(255) collate utf8_bin NOT NULL,
		`answer_3` varchar(255) collate utf8_bin NOT NULL,
		`answer_4` varchar(255) collate utf8_bin NOT NULL,
		`answer_5` varchar(255) collate utf8_bin NOT NULL,
		`answer_6` varchar(255) collate utf8_bin NOT NULL,
		`answer_7` varchar(255) collate utf8_bin NOT NULL,
		`answer_8` varchar(255) collate utf8_bin NOT NULL,
		`answer_9` varchar(255) collate utf8_bin NOT NULL,
		`answer_10` varchar(255) collate utf8_bin NOT NULL,
		`answer_11` varchar(255) collate utf8_bin NOT NULL,
		`answer_12` varchar(255) collate utf8_bin NOT NULL,
		`answer_13` varchar(255) collate utf8_bin NOT NULL,
		`answer_14` varchar(255) collate utf8_bin NOT NULL,
		`answer_15` varchar(255) collate utf8_bin NOT NULL,
		PRIMARY KEY  (`poll_id`,`language_id`), 
		KEY `question` (`question`)) 
		ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$create_poll_reactions = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_poll_reactions` 
		(`poll_reaction_id` int(11) NOT NULL auto_increment, 
		`poll_id` int(11) NOT NULL, 
		`answer` int(11) NOT NULL, 
		PRIMARY KEY  (`poll_reaction_id`)) 
		ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		$create_poll_to_store = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX."news_poll_to_store` (
		`poll_id` int(11) NOT NULL, 
		`store_id` int(11) NOT NULL, 
		PRIMARY KEY  (`poll_id`, `store_id`)) 
		ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
		
		$this->db->query($create_poll_descriptions);
		$this->db->query($create_poll_reactions);
		$this->db->query($create_poll_to_store);
	}
	public function hideSampleNews() {		
		$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `key` = 'config_news_sample_installed'");
		$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings',`key` = 'config_news_sample_installed',value = '1'");			
	}
	
	public function uninstall() {
			$this->delete_module_setting();
			$this->uninstall_module();
			$this->delete_cache();
	}
	public function drop_db() {
			$this->delete_seo_keyword();	
			$this->db->query("DROP TABLE `".DB_PREFIX."news_article`,
			`".DB_PREFIX."news_article_description`,
			`".DB_PREFIX."news_article_image`,
			`".DB_PREFIX."news_article_to_category`,
			`".DB_PREFIX."news_article_to_download`,
			`".DB_PREFIX."news_article_to_layout`,
			`".DB_PREFIX."news_article_to_store`,
			`".DB_PREFIX."news_author`,
			`".DB_PREFIX."news_author_ip`,
			`".DB_PREFIX."news_author_ip_blacklist`,
			`".DB_PREFIX."news_comment`,
			`".DB_PREFIX."news_download`,
			`".DB_PREFIX."news_download_description`,
			`".DB_PREFIX."news_poll`,
			`".DB_PREFIX."news_poll_description`,
			`".DB_PREFIX."news_poll_reactions`,
			`".DB_PREFIX."news_poll_to_store`,
			`".DB_PREFIX."news_related_article`,
			`".DB_PREFIX."news_related_product`;");
			$this->delete_cache();
			$this->delete_news_setting();
			$this->db->query("UPDATE " . DB_PREFIX . "category SET related_id = '0'");
	}
	public function empty_db() {	
			$this->delete_seo_keyword();	
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_description`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_image`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_to_category`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_to_download`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_to_layout`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_article_to_store`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_author`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_author_ip`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_author_ip_blacklist`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_category`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_category_description`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_category_to_layout`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_category_to_store`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_comment`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_download`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_download_description`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_poll`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_poll_description`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_poll_reactions`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_poll_to_store`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_related_article`");
			$this->db->query("TRUNCATE `".DB_PREFIX."news_related_product`;");	
			$this->db->query("UPDATE " . DB_PREFIX . "category SET related_id = '0'");
			$this->delete_cache();
			
	}
	public function optimize() {
			$this->db->query("OPTIMIZE TABLE `".DB_PREFIX."news_article`,
								`".DB_PREFIX."news_article_description`,
								`".DB_PREFIX."news_article_image`,
								`".DB_PREFIX."news_article_to_category`,
								`".DB_PREFIX."news_article_to_download`,
								`".DB_PREFIX."news_article_to_layout`,
								`".DB_PREFIX."news_article_to_store`,
								`".DB_PREFIX."news_category`,
								`".DB_PREFIX."news_category_description`,
								`".DB_PREFIX."news_category_to_layout`,
								`".DB_PREFIX."news_category_to_store`,
								`".DB_PREFIX."news_author`,
								`".DB_PREFIX."news_author_ip`,
								`".DB_PREFIX."news_author_ip_blacklist`,
								`".DB_PREFIX."news_comment`,
								`".DB_PREFIX."news_download`,
								`".DB_PREFIX."news_download_description`,
								`".DB_PREFIX."news_poll`,
								`".DB_PREFIX."news_poll_description`,
								`".DB_PREFIX."news_poll_reactions`,
								`".DB_PREFIX."news_poll_to_store`,
								`".DB_PREFIX."news_related_article`,
								`".DB_PREFIX."news_related_product`;");
	}
	public function uninstall_module() {
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_author'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_by_type'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_category'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_custom_footer'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_free_download'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_list'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_newsletter_subscribe'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_poll'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_search'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."extension` WHERE `code` = 'article_slideshow'");		
	}
	
	public function delete_news_setting() {		
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_all_settings'");
	}
	
	public function delete_seo_keyword() {
		/*category*/
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "news_category"); 		
		foreach ($query->rows as $result) {			
		$this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'article_category_id=" . $result['article_category_id']. "'");
		}
		/*article*/
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "news_article"); 		
		foreach ($query->rows as $result) {			
		$this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'article_id=" . $result['article_id']. "'");
		}
		/*author*/
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "news_author"); 		
		foreach ($query->rows as $result) {			
		$this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'author_id=" . $result['author_id']. "'");
		}
	}
	public function delete_module_setting() {		
			/*SETTINGS*/ 		
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_author'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_by_type'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_category'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_custom_footer'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_free_download'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_list'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_newsletter_subscribe'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_poll'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_search'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_slideshow'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_shoutbox'");
	}
	
	public function delete_cache() {	
	/*cache*/ 			
		$this->cache->delete('article_category');
		$this->cache->delete('article');
		$this->cache->delete('poll');
	}
	public function installSampleNews() {	
	
		$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `key` = 'config_news_sample_installed'");
		$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_all_settings', `key` = 'config_news_sample_installed', value = '1'");	
		
		$this->empty_db();
						
			
		$news_article="INSERT INTO `".DB_PREFIX."news_article` (`article_id`,`model`,`image`,`author_id`,`sort_order`,`status`,`date_added`,`date_modified`,`viewed`,`poll_id`) VALUES (1,'','data/easy_article/article/04.jpg',2,999,1,'2013-02-10 00:34:33','2013-02-12 03:51:19',82,3),
		(2,'','data/easy_article/article/02.jpg',16,999,1,'2013-02-10 18:48:24','2013-02-12 03:50:48',7,3),
		(3,'','data/easy_article/article/03.jpg',14,999,1,'2013-02-11 02:02:33','2013-02-12 02:54:53',0,3),
		(4,'','data/easy_article/article/01.jpg',10,999,1,'2013-02-11 02:02:33','2013-02-12 03:49:43',63,3),
		(5,'','data/easy_article/article/05.jpg',12,999,1,'2013-02-11 22:41:22','2013-02-12 03:50:19',1,3),
		(6,'','data/easy_article/article/06.jpg',6,999,1,'2013-02-11 22:43:39','2013-02-12 03:48:34',3,3),
		(7,'','data/easy_article/article/07.jpg',6,999,1,'2013-02-11 22:48:18','2013-02-12 03:51:57',0,3),
		(8,'','data/easy_article/article/08.jpg',5,999,1,'2013-02-11 23:36:34','2013-02-12 03:53:03',3,3),
		(9,'','data/easy_article/article/02_1.jpg',2,999,1,'2013-02-11 23:38:06','2013-02-12 03:52:32',0,3),
		(10,'','data/easy_article/article/09.jpg',8,999,1,'2013-02-11 23:41:11','2013-02-12 03:56:06',0,3),
		(11,'','data/easy_article/article/10_3.jpg',23,999,1,'2013-02-11 23:44:26','2013-02-12 03:55:13',0,3),
		(12,'','data/easy_article/article/11_1.jpg',1,999,1,'2013-02-11 23:46:33','2013-02-12 03:58:05',0,3),
		(13,'','data/easy_article/article/13.jpg',5,999,1,'2013-02-11 23:50:23','2013-02-12 03:58:41',1,3),
		(14,'','data/easy_article/article/05.jpg',11,999,1,'2013-02-12 00:25:41','2013-02-12 03:54:38',0,3),
		(15,'','data/easy_article/article/14_1.jpg',13,999,1,'2013-02-12 03:22:56','2013-02-12 03:42:11',0,3),
		(16,'','data/easy_article/article/15_2.jpg',17,999,1,'2013-02-12 03:25:54','2013-02-12 03:40:27',0,3),
		(17,'','data/easy_article/article/16_3.jpg',6,999,1,'2013-02-12 03:27:56','2013-02-12 03:41:35',2,3),
		(18,'','data/easy_article/article/17.jpg',5,999,1,'2013-02-12 03:31:15','2013-02-12 03:39:31',5,3),
		(19,'','data/easy_article/article/18.jpg',5,999,1,'2013-02-12 03:34:54','2013-02-12 03:42:44',0,3);";
			
			
			$news_article_to_category="INSERT INTO `".DB_PREFIX."news_article_to_category` (`article_id`, `article_category_id`) VALUES
			(1, 1),(1, 3),(1, 6),(1, 15),(2, 1),(2, 3),(2, 4),(2, 15),(3, 3),(3, 5),(3, 7),(3, 15),(4, 1),(4, 2),(4, 3),(4, 5),(4, 15),(5, 1),(5, 4),(5, 5),(6, 1),(6, 2),
			(6, 4),(7, 1),(7, 5),(7, 7),(8, 1),(8, 5),(8, 6),(8, 7),(9, 1),(9, 2),(9, 3),(9, 4),(9, 5),(9, 6),(9, 7),(9, 15),(10, 8),(10, 9),(10, 11),(10, 13),(11, 8),
			(11, 10),(11, 12),(11, 14),(12, 8),(12, 9),(12, 10),(12, 13),(12, 14),(13, 8),(13, 9),(13, 11),(13, 12),(14, 8),(14, 10),(14, 11),(14, 13),(14, 14),(15, 9),
			(15, 11),(15, 13),(15, 16),(15, 18),(16, 3),(16, 4),(16, 5),(16, 7),(16, 10),(16, 12),(16, 13),(16, 16),(16, 18),(17, 2),(17, 6),(17, 8),(17, 11),(17, 13),
			(17, 15),(17, 16),(17, 18),(18, 5),(18, 7),(18, 10),(18, 11),(18, 13),(18, 14),(18, 16),(18, 18),(19, 3),(19, 4),(19, 7),(19, 9),(19, 10),(19, 12),(19, 16),(19, 18);";
			
			
			$news_article_to_download="INSERT INTO `".DB_PREFIX."news_article_to_download` (`article_id`, `download_id`) VALUES (2, 1),(3, 1),(4, 1),(4, 3),(4, 4),(4, 6),(6, 3),(9, 1),(9, 3),(10, 3);";
			$news_article_to_store="INSERT INTO `".DB_PREFIX."news_article_to_store` (`article_id`, `store_id`) VALUES (1, 0),(2, 0),(3, 0),(4, 0),(5, 0),(6, 0),(7, 0),(8, 0),(9, 0),(10, 0),(11, 0),(12, 0),(13, 0),(14, 0),(15, 0),(16, 0),(17, 0),(18, 0),(19, 0);";
			$news_author="INSERT INTO `".DB_PREFIX."news_author` (`author_id`, `author`, `image`, `store_id`, `firstname`, `lastname`, `author_description`, `email`, `telephone`, `website`, `password`, `salt`, `address`, `city`, `country_id`, `zone_id`, `ip`, `status`, `approved`, `token`, `date_added`, `newsletter`, `sort_order`) VALUES
(1, 'Taylor Lautner', 'data/easy_article/author/12.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 12),
(2, 'Alexander Skarsgard', 'data/easy_article/author/19.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 0),
(3, 'Monica Spencer', 'data/easy_article/author/02.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 2),
(4, 'Johnny Depp', 'data/easy_article/author/22.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 22),
(5, 'Adam Smitch', 'data/easy_article/author/13.jpg', 0, 'Adam', 'Smitch', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'adam@mail.com', '01234567890', 'http://www.opencart.com', '89a6bdff7a4b4a03be6318db4323148c799457ce', '8e775ab8f', 'Don Street', 'District 8', 222, 3525, '127.0.0.1', 1, 1, '', '0000-00-00 00:00:00', 0, 13),
(6, 'James McAvoy', 'data/easy_article/author/21.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 21),
(7, 'Shia LaBeouf', 'data/easy_article/author/20.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 20),
(8, 'John Team', 'data/easy_article/author/14.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 14),
(23, 'Will Ferrell', 'data/easy_article/author/23.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 23),
(9, 'Tom Cruise', 'data/easy_article/author/18.jpg', 0, 'Tom', 'Cruise', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'demo@demo.com', '01234567890', 'http://www.opencart.com', '0a30d403ca5e9346136cb96831694a0171ffdf34', '5549332b1', 'Address', 'City', 223, 3631, '0', 1, 0, '', '0000-00-00 00:00:00', 0, 18),
(10, 'Alex  Zert', 'data/easy_article/author/15.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 15),
(11, 'Robert Pattinson', 'data/easy_article/author/16.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 0),
(12, 'Chace Crawford', 'data/easy_article/author/17.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 17),
(13, 'Kristen Stewart', 'data/easy_article/author/01.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 1),
(14, 'Cameron Diaz', 'data/easy_article/author/03.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 3),
(15, 'Sandra Bullock', 'data/easy_article/author/04.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 4),
(16, 'Angelina Jolie', 'data/easy_article/author/05.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 0),
(17, 'Charlize Theron', 'data/easy_article/author/06.jpg', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '0', 0, 0, '', '0000-00-00 00:00:00', 0, 6),
(18, 'Julia Roberts', 'data/easy_article/author/07.jpg', 0, 'Julia', 'Roberts', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'julia@mail.com', '01234567890', 'Hoi Wing Road', 'cca8dc6649e3edf055512202be9a7c28297ba985', '0c198bbc8', 'Address', 'City', 223, 3670, '0', 1, 0, '', '0000-00-00 00:00:00', 0, 7),
(19, 'Sarah Jessica', 'data/easy_article/author/08.jpg', 0, 'Sarah', 'Jessica', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'sarah@mail.com', '01234567890', 'http://www.opencart.com', '0d37134348b12c28833c9161e0f89128c95edc49', '84780295a', 'Don Street', 'Hoi Wing Road', 222, 3573, '0', 1, 0, '', '0000-00-00 00:00:00', 0, 8),
(20, 'Meryl Streep', 'data/easy_article/author/09.jpg', 0, 'Meryl', 'Streep', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'meryl@mail.com', '01234567890', 'http://www.opencart.com', '8de2ef0735812a66a588a2a33c00dbae01fc1637', 'ece443d5d', 'Don Street', 'City', 223, 3625, '0', 1, 0, '', '0000-00-00 00:00:00', 0, 9),
(21, 'Kristen Wiig', 'data/easy_article/author/10.jpg', 0, 'kristen', 'wiig', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'kristen@mail.com', '01234567890', 'http://www.opencart.com', 'fda06916c4ba914d8f38bc2a2b6e7b73ca53722d', '69fe492d1', 'Don Street', '22 Hoi Wing Road', 223, 3630, '0', 1, 0, '', '0000-00-00 00:00:00', 0, 10),
(22, 'Jennifer Aniston', 'data/easy_article/author/11.jpg', 0, 'Jennifer', 'Aniston', '&lt;p&gt;\r\n	&lt;span style=&quot;color: rgb(102, 102, 102); font-family: Verdana, Geneva, sans-serif; font-size: 11px;&quot;&gt;Can you please give us a brief summary of your history, experience and qualifications.&lt;/span&gt;&lt;/p&gt;\r\n', 'jennifer@mail.com', '01234567890', 'http://www.apple.com', '811bd9562fff426e1e381687b214bfc387095377', 'd8138e239', 'Address', 'City', 223, 3613, '127.0.0.1', 1, 1, '', '0000-00-00 00:00:00', 0, 11);";
			
			
			$news_category="INSERT INTO `".DB_PREFIX."news_category` (`article_category_id`, `image`, `parent_id`, `top`, `column`, `sort_order`, `status`, `date_added`, `date_modified`) VALUES
			(1, 'data/easy_article/category/01.png', 0, 1, 1, 1000, 1, '2013-02-09 20:41:17', '2013-02-12 02:48:21'),
			(2, 'data/easy_article/category/06.jpg', 1, 0, 1, 1006, 1, '2013-02-10 00:07:07', '2013-02-11 21:32:41'),
			(3, 'data/easy_article/category/02.jpg', 15, 0, 1, 2001, 1, '2013-02-10 00:09:08', '2013-02-12 02:50:49'),
			(4, 'data/easy_article/category/04.png', 1, 0, 1, 1003, 1, '2013-02-10 00:10:19', '2013-02-11 21:32:22'),
			(5, 'data/easy_article/category/05.jpg', 15, 0, 1, 2003, 1, '2013-02-10 00:11:29', '2013-02-12 02:52:16'),
			(6, 'data/easy_article/category/03.jpg', 15, 0, 1, 2002, 1, '2013-02-10 00:13:11', '2013-02-12 02:52:02'),
			(7, 'data/easy_article/category/07.jpeg', 1, 0, 1, 1007, 1, '2013-02-10 16:27:42', '2013-02-11 21:32:52'),
			(8, 'data/easy_article/category/17.jpg', 0, 0, 1, 3000, 1, '2013-02-10 16:29:49', '2013-02-12 02:49:30'),
			(9, 'data/easy_article/category/15.jpg', 8, 0, 1, 3001, 1, '2013-02-11 22:09:24', '2013-02-12 02:49:42'),
			(10, 'data/easy_article/category/13.jpg', 8, 0, 1, 3002, 1, '2013-02-11 22:11:49', '2013-02-12 02:49:50'),
			(11, 'data/easy_article/category/14.jpg', 8, 0, 1, 3003, 1, '2013-02-11 22:12:42', '2013-02-12 02:50:02'),
			(12, 'data/easy_article/category/16.jpg', 8, 0, 1, 3004, 1, '2013-02-11 22:14:30', '2013-02-12 02:50:17'),
			(13, 'data/easy_article/category/16.png', 8, 0, 1, 3005, 1, '2013-02-11 22:15:52', '2013-02-12 02:50:23'),
			(14, 'data/easy_article/category/18.png', 8, 0, 1, 3006, 1, '2013-02-11 22:17:52', '2013-02-12 02:50:32'),
			(15, 'data/easy_article/category/08.jpg', 0, 0, 1, 2000, 1, '2013-02-12 02:49:18', '2013-02-12 02:51:36'),
			(16, 'data/easy_article/category/04.png', 0, 0, 1, 4000, 1, '2013-02-12 03:14:00', '2013-02-12 03:14:00'),
			(17, 'data/easy_article/category/12.jpg', 16, 0, 1, 4001, 1, '2013-02-12 03:15:33', '2013-02-12 03:18:36'),
			(18, 'data/easy_article/article/17.jpg', 16, 0, 1, 4002, 1, '2013-02-12 03:21:07', '2013-02-12 03:21:07');";
			$news_category_to_store="INSERT INTO `".DB_PREFIX."news_category_to_store` (`article_category_id`, `store_id`) VALUES
			(1, 0),(2, 0),(3, 0),(4, 0),(5, 0),(6, 0),(7, 0),(8, 0),(9, 0),(10, 0),(11, 0),(12, 0),(13, 0),(14, 0),(15, 0),(16, 0),(17, 0),(18, 0);";
			
			$news_comment="INSERT INTO `".DB_PREFIX."news_comment` (`comment_id`, `article_id`, `customer_id`, `author`, `text`, `rating`, `status`, `date_added`, `date_modified`) VALUES
			(1, 8, 0, 'Alex Zert', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum bibendum libero et lectus faucibus vehicula.', 5, 1, '2013-02-12 04:15:54', '0000-00-00 00:00:00'),
			(2, 8, 0, 'Alexander Skarsgard', 'Quisque fringilla, lectus in pulvinar euismod, tortor lectus fringilla lacus, at sollicitudin mi felis nec quam. ', 5, 0, '2013-02-12 04:16:46', '0000-00-00 00:00:00');";
			
			$news_download="INSERT INTO `".DB_PREFIX."news_download` (`download_id`, `filename`, `mask`, `auth_key`, `remaining`, `date_added`) VALUES
			(1, '11.jpg.f73517cb42b6f5b6b720beb98387d251', '11.jpg', '6fcc3873c49ff72ad242bbbaf3bdf251', 1, '2013-02-10 20:22:43'),
			(3, '14_1.jpg.82b3607e15cb0e27a05fdc8a27cf3053', '14_1.jpg', '9d075bf3f5b8ba694adf51c0495e7623', 1, '2013-02-11 17:19:12'),
			(4, '03.jpg.4dbc8596423ec3cb0e78836ab1309cbd', '03.jpg', 'dc50e05e4816040fd2e4413009470ffa', 1, '2013-02-11 17:20:19'),
			(6, '01.png.42251e81a8e495b474f57ff00f33ecc2', '01.png', '16c8c604be3b83fcce5fddcdf62c55fe', 1, '2013-02-11 18:12:07');";
			
			$news_related_article="INSERT INTO `".DB_PREFIX."news_related_article` (`article_id`, `article_related_id`) VALUES
			(1, 2),(1, 5),(1, 9),(2, 1),(2, 2),(2, 5),(2, 6),(3, 5),(3, 7),(4, 5),(4, 10),(5, 1),(5, 2),(5, 3),(5, 4),(5, 6),(5, 7),(5, 10),(6, 2),
			(6, 5),(6, 10),(7, 3),(7, 5),(7, 9),(8, 9),(9, 1),(9, 7),(9, 8),(10, 4),(10, 5),(10, 6),(10, 11),(10, 12),(10, 13),(10, 14),(10, 16),
			(11, 10),(11, 12),(11, 13),(11, 14),(12, 10),(12, 11),(12, 13),(12, 14),(12, 16),(13, 10),(13, 11),(13, 12),(13, 14),(13, 16),(14, 10),
			(14, 11),(14, 12),(14, 13),(15, 16),(15, 19),(16, 10),(16, 12),(16, 13),(16, 15),(16, 19),(17, 19),(18, 19),(19, 15),(19, 16),(19, 17),(19, 18);";
			
			$news_related_product="INSERT INTO `".DB_PREFIX."news_related_product` (`article_id`, `product_related_id`) VALUES
			(4, 28),(4, 30),(4, 33),(4, 40),(4, 42),(4, 47),(5, 28),(5, 30),(5, 42),(5, 43),(5, 47),(6, 33),(6, 35),(6, 46),(7, 49),(9, 28),(9, 30),
			(9, 42),(9, 43),(9, 47),(10, 29),(10, 33),(10, 35),(10, 43),(10, 44),(11, 33),(11, 40),(11, 46),(11, 48),(13, 29),(13, 42),(13, 44),
			(13, 46),(13, 47),(14, 30),(14, 33),(14, 42),(14, 43),(14, 44),(14, 46),(16, 43),(16, 44),(16, 45),(16, 46),(16, 47),(19, 28),(19, 29),
			(19, 40),(19, 41),(19, 49);";
			
			$news_poll="INSERT INTO `".DB_PREFIX."news_poll` (`poll_id`,`date_added`) VALUES (1,'2013-06-03 00:36:53'),(2,'2013-06-03 00:36:53'),(3,'2013-06-03 00:36:53');";
			$news_poll_to_store="INSERT INTO `".DB_PREFIX."news_poll_to_store` (`poll_id`,`store_id`) VALUES (1,0),(2,0),(3,0);";
			$this->db->query($news_article);
			$this->db->query($news_article_to_category);
			$this->db->query($news_article_to_download);
			$this->db->query($news_article_to_store);
			$this->db->query($news_author);
			$this->db->query($news_category);
			$this->db->query($news_category_to_store);
			$this->db->query($news_comment);
			$this->db->query($news_download);
			$this->db->query($news_related_article);
			$this->db->query($news_related_product);
			$this->db->query($news_poll);
			$this->db->query($news_poll_to_store);
				
			$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "language ORDER BY sort_order, name");
	   			foreach ($query->rows as $result) {
				$language_id=$result['language_id'];		
	$this->db->query("INSERT INTO `".DB_PREFIX."news_poll_description` (`poll_id`,`language_id`,`question`,`answer_1`,`answer_2`,`answer_3`,`answer_4`,`answer_5`,`answer_6`, `answer_7`,`answer_8`,`answer_9`,`answer_10`,`answer_11`,`answer_12`,`answer_13`,`answer_14`,`answer_15`) VALUES			
(1,".(int)$language_id.",'How do you find us?','From Opencart.com','From Google.com','My friends introduced','','','','','','','','','','','',''),
(2,".(int)$language_id.",'Do you like this extension?','Yes','No','Other answer','Any answer...','','','','','','','','','','',''),(3,".(int)$language_id.",'Add any poll if you want?','Yes','No','Other answer','Any answer...','','','','','','','','','','','');");	


			$this->db->query("INSERT INTO `".DB_PREFIX."news_article_image` (`article_id`,`image`,`sort_order`,`language_id`,`image_description`) VALUES 
			(19,'data/easy_article/article/18_2.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(19,'data/easy_article/article/18_3.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(19,'data/easy_article/article/18_4.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(19,'data/easy_article/article/18_1.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(18,'data/easy_article/article/17_4.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(18,'data/easy_article/article/17_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(18,'data/easy_article/article/17_1.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(18,'data/easy_article/article/17_2.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(17,'data/easy_article/article/16_4.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(16,'data/easy_article/article/15_4.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(16,'data/easy_article/article/15.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(17,'data/easy_article/article/16.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(17,'data/easy_article/article/16_1.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(17,'data/easy_article/article/16_2.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(16,'data/easy_article/article/15_1.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(16,'data/easy_article/article/15_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(16,'data/easy_article/article/15_5.jpg',4,".(int)$language_id.",'Addition Image multi languages description.'),
			(2,'data/easy_article/article/02_2.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(2,'data/easy_article/article/02_1.jpg',13,".(int)$language_id.",'Addition Image multi languages description.'),
			(12,'data/easy_article/article/11.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(12,'data/easy_article/article/11_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(15,'data/easy_article/article/14_4.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(15,'data/easy_article/article/14_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(15,'data/easy_article/article/14_2.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(15,'data/easy_article/article/14.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(13,'data/easy_article/article/12_1.jpg',4,".(int)$language_id.",'Addition Image multi languages description.'),
			(13,'data/easy_article/article/12.jpg',3,".(int)$language_id.",'Addition Image multi languages description.'),
			(13,'data/easy_article/article/13_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(13,'data/easy_article/article/13_2.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(13,'data/easy_article/article/13_1.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(9,'data/easy_article/article/02_2.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(9,'data/easy_article/article/02.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(12,'data/easy_article/article/11_2.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(10,'data/easy_article/article/09_1.jpg',0,".(int)$language_id.",'Addition Image multi languages description.'),
			(10,'data/easy_article/article/09_2.jpg',1,".(int)$language_id.",'Addition Image multi languages description.'),
			(10,'data/easy_article/article/09_3.jpg',2,".(int)$language_id.",'Addition Image multi languages description.'),
			(10,'data/easy_article/article/09_4.jpg',3,".(int)$language_id.",'Addition Image multi languages description.');");	

			$this->db->query("INSERT INTO `".DB_PREFIX."news_category_description` (`article_category_id`, `language_id`, `name`, `description`, `meta_description`, `meta_keyword`) VALUES
			(2, ".(int)$language_id.", 'Entertainment ', '&lt;p&gt;\r\n	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce et elit orci. Vivamus quis molestie lectus. Sed volutpat nunc vel est dictum sit amet placerat orci convallis. Nunc convallis varius pretium. Quisque at lorem ut tortor feugiat egestas id vel justo. Nunc facilisis risus mi, mollis tincidunt lacus. Quisque dolor metus, imperdiet vitae consectetur sed, tempor sit amet purus. Nunc dignissim sapien pulvinar neque semper non iaculis turpis facilisis. Donec et ipsum dui. Nunc vel tellus in tellus dignissim gravida sit amet eget turpis.&lt;/p&gt;\r\n', '', ''),
			(4, ".(int)$language_id.", 'Technology', '&lt;p&gt;\r\n	Fusce et elit orci. Vivamus quis molestie lectus. Sed volutpat nunc vel est dictum sit amet placerat orci convallis. Nunc convallis varius pretium. Quisque at lorem ut tortor feugiat egestas id vel justo. Nunc facilisis risus mi, mollis tincidunt lacus. Quisque dolor metus, imperdiet vitae consectetur sed, tempor sit amet purus. Nunc dignissim sapien pulvinar neque semper non iaculis turpis facilisis. Donec et ipsum dui. Nunc vel tellus in tellus dignissim gravida sit amet eget turpis.&lt;/p&gt;\r\n', '', ''),
			(3, ".(int)$language_id.", 'Creative ', '&lt;p&gt;Cras vulputate gravida pellentesque. Mauris ultricies metus id sapien porta vulputate. Cras feugiat nunc id mi condimentum mattis. Duis placerat auctor enim, sed luctus diam tempor posuere. Proin elementum, sem ac gravida ornare, lorem mi egestas lacus, ac dapibus neque elit ac est. In ornare mollis libero a elementum. Nulla eleifend dapibus massa, et varius metus rhoncus sed. Cras ligula augue, interdum a lobortis id, pharetra at odio.&lt;/p&gt;\r\n', '', ''),
			(6, ".(int)$language_id.", 'Corporate', '&lt;p&gt;Cras vitae risus a eros vehicula volutpat et ac neque. Proin eu dui eu ante bibendum accumsan. Maecenas ultrices lacinia dui, ut fermentum elit convallis at. Vestibulum ut enim at nibh sollicitudin condimentum vel non velit.Quisque at lorem ut tortor feugiat egestas id vel justo. Nunc facilisis risus mi, mollis tincidunt lacus. Quisque dolor metus, imperdiet vitae consectetur sed, tempor sit amet purus. Nunc dignissim sapien pulvinar neque semper non iaculis turpis facilisis. Donec et ipsum dui. Nunc vel tellus in tellus dignissim gravida sit amet eget turpis.&lt;/p&gt;\r\n', '', ''),
			(1, ".(int)$language_id.", 'Website Templates', '&lt;p&gt;Cras vulputate gravida pellentesque. Mauris ultricies metus id sapien porta vulputate. Cras feugiat nunc id mi condimentum mattis. Duis placerat auctor enim, sed luctus diam tempor posuere. Proin elementum, sem ac gravida ornare, lorem mi egestas lacus, ac dapibus neque elit ac est. In ornare mollis libero a elementum. Nulla eleifend dapibus massa, et varius metus rhoncus sed. Cras ligula augue, interdum a lobortis id, pharetra at odio. Curabitur ornare, felis et facilisis volutpat, libero quam aliquet odio, vel tempus urna diam eget nisl. Morbi et nisi odio, mollis lacinia mauris. Donec vel mi a justo ornare pellentesque et vitae justo. Pellentesque egestas pulvinar lacinia.&lt;/p&gt;\r\n', '', ''),
			(5, ".(int)$language_id.", 'Nonprofit', '&lt;p&gt;Mauris ultricies metus id sapien porta vulputate. Cras feugiat nunc id mi condimentum mattis. Duis placerat auctor enim, sed luctus diam tempor posuere. Proin elementum, sem ac gravida ornare, lorem mi egestas lacus, ac dapibus neque elit ac est. In ornare mollis libero a elementum. Nulla eleifend dapibus massa, et varius metus rhoncus sed. Cras ligula augue, interdum a lobortis id, pharetra at odio. Curabitur ornare, felis et facilisis volutpat, libero quam aliquet odio, vel tempus urna diam eget nisl. Morbi et nisi odio, mollis lacinia mauris. Donec vel mi a justo ornare pellentesque et vitae justo. Pellentesque egestas pulvinar lacinia.&lt;/p&gt;\r\n', '', ''),
			(7, ".(int)$language_id.", 'Personal', '&lt;p&gt;\r\n	Fusce non tortor sed ipsum aliquet adipiscing. Sed sem sem, varius quis dictum sit amet, ultrices vitae tortor. Nulla commodo aliquet rutrum. Morbi adipiscing molestie adipiscing. Nulla facilisi. Etiam elementum suscipit porttitor. Nulla interdum varius augue. Phasellus sit amet odio enim.&lt;/p&gt;\r\n&lt;p&gt;\r\n	Proin congue, nibh non sodales faucibus, elit sem faucibus dui, non congue augue tortor eget dolor. Phasellus sodales iaculis sapien in mattis. Curabitur et leo ligula. Curabitur sed consequat mauris. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Etiam non lectus enim. Aliquam erat volutpat. Vestibulum non risus eu augue feugiat dictum. In non massa porta tortor volutpat pharetra sed ut risus. In mollis mi a libero volutpat scelerisque. Pellentesque eu dolor ac augue interdum pellentesque aliquam ut ligula.&lt;/p&gt;\r\n&lt;p&gt;\r\n	Suspendisse ac leo a diam lobortis viverra. Integer dui justo, euismod eget posuere at, placerat non sapien. Integer vitae mauris at nibh faucibus ornare ut ut dui. Nunc varius aliquet dolor, vel accumsan dolor cursus ac. Nullam laoreet metus sit amet purus cursus aliquam. In ligula nisl, interdum congue egestas a, commodo sed velit. Nullam elit metus, auctor quis lacinia et, sollicitudin quis velit. Donec convallis, leo in dictum venenatis, lorem dolor pellentesque felis, nec commodo enim leo sit amet neque. Duis dapibus tortor non ante blandit et interdum leo accumsan. Etiam faucibus dictum nisl, sed consequat sapien mollis non. Nulla fringilla mauris ut enim dictum commodo. Curabitur tincidunt lectus at ligula ultricies viverra.&lt;/p&gt;\r\n&lt;p&gt;\r\n	Morbi neque nulla, iaculis eu tincidunt feugiat, vestibulum ut dui. Donec vestibulum tellus vitae neque pretium ac feugiat nisi varius. Mauris rhoncus tortor sed dolor pharetra sollicitudin. Nam et sem sit amet quam volutpat tincidunt venenatis ac elit. Etiam condimentum laoreet aliquet. Cras vitae elementum dui. Morbi pharetra dui feugiat lacus varius venenatis. Mauris faucibus viverra neque, eu hendrerit quam interdum non.&lt;/p&gt;\r\n&lt;p&gt;\r\n	Mauris arcu ante, porttitor in congue et, molestie nec ante. Maecenas mollis, diam sed vulputate fermentum, quam justo tincidunt velit, sed hendrerit turpis odio vel elit. Nulla iaculis erat sed ligula commodo vitae accumsan sapien facilisis. Curabitur odio quam, tincidunt a adipiscing eget, aliquet condimentum lorem. Etiam ornare fringilla fringilla. Aliquam erat volutpat. Aenean placerat, diam non hendrerit euismod, neque arcu lacinia nibh, at faucibus ipsum diam in diam. Aenean id velit nisi.&lt;/p&gt;\r\n', '', ''),
			(8, ".(int)$language_id.", 'eCommerce', '&lt;p&gt;Donec tincidunt turpis eget orci facilisis suscipit. Fusce et elit felis. Donec vel tortor metus. In ac tortor nibh. Praesent sodales nulla ac risus aliquam non auctor nisl pulvinar. Nunc sed lorem sem, ac adipiscing nisi. Maecenas a lectus sit amet nibh tincidunt sollicitudin ultrices eu leo. Maecenas in ligula et lectus tincidunt porta. Integer dapibus purus nulla, at ornare lacus. Ut vehicula aliquet mauris, a blandit nunc scelerisque id. Curabitur non nibh tristique dui vehicula vulputate. Aenean bibendum ipsum magna. In lorem velit, feugiat et blandit eget, sodales ac turpis.&lt;/p&gt;\r\n', '', ''),
			(9, ".(int)$language_id.", 'Opencart', '&lt;p&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla tristique nibh vitae neque facilisis non facilisis erat dictum. Nulla fringilla, lectus at aliquam egestas, felis nulla euismod velit, sed rutrum lacus ligula non ipsum. Sed mollis, massa ut mattis mattis, nibh est rutrum urna, eu dapibus odio magna sit amet nibh. Vivamus quis erat felis. Donec sed convallis nunc. Maecenas velit tortor, porta eu mollis sed, lacinia vitae augue. Vivamus lobortis congue risus sit amet hendrerit. Etiam sem enim, egestas vel hendrerit nec, mollis at elit. Nam molestie nisi sed mauris aliquam quis suscipit mi ultricies. Donec volutpat malesuada mi, eget gravida massa rutrum et.&lt;/p&gt;\r\n', '', ''),
			(10, ".(int)$language_id.", 'Magento', '&lt;p&gt;Phasellus accumsan, quam non dignissim mattis, lectus justo pharetra lorem, vel rutrum diam lorem laoreet est. In hac habitasse platea dictumst. Cras sollicitudin faucibus justo, id egestas nunc eleifend non. Donec pharetra elit vel justo posuere vestibulum. Fusce orci leo, rutrum vitae pharetra ac, commodo sit amet mauris. Aliquam tempus nisl mi. Phasellus a massa odio, scelerisque commodo erat. Curabitur non dapibus tortor. Sed a tellus erat.&lt;/p&gt;\r\n', '', ''),
			(11, ".(int)$language_id.", 'Shopify', '&lt;p&gt;Pellentesque vel mattis metus. Suspendisse potenti. Curabitur congue nisl non nibh aliquam ac euismod elit laoreet. Maecenas a venenatis lacus. Suspendisse ante tellus, porttitor nec ultricies et, dignissim at dolor. Mauris adipiscing dui id lorem eleifend in feugiat erat sollicitudin. Donec vitae justo orci.&lt;/p&gt;\r\n', 'Pellentesque vel mattis metus. Suspendisse potenti.', 'Curabitur, congue nisl, non nibh aliquam ac eu'),
			(12, ".(int)$language_id.", 'osCommerce ', '&lt;p&gt;Morbi quis pellentesque quam. Sed sed lectus ac sem fringilla porttitor. In ornare lectus vitae augue vehicula fermentum. Integer vitae enim nec risus vestibulum varius tempus vel quam. Nunc scelerisque, magna non sollicitudin convallis, velit magna sagittis nunc, vitae imperdiet lorem ligula ac erat. Aenean fringilla, eros at consectetur luctus, arcu odio rhoncus ante, at tincidunt nulla augue eu tellus. Integer egestas, mauris id dictum dignissim, nisi lacus pulvinar nisl, eu pretium leo turpis in lorem. Nulla facilisi. Mauris malesuada diam ac eros gravida consectetur. Etiam gravida scelerisque massa, sit amet ultricies massa egestas et. Donec ultrices nibh ac orci gravida ultrices. Donec dictum, magna nec ultrices convallis, elit mi consectetur arcu, at facilisis libero augue at tellus. Suspendisse quis lorem sit amet quam fermentum varius. Donec rhoncus, elit sit amet ultrices iaculis, risus lacus ultrices justo, in semper eros eros at tellus.&lt;/p&gt;\r\n', 'Morbi quis pellentesque quam. ', 'Morbi quis, pellentesque quam, Sed sed, lectus ac sem, fringilla porttitor. '),
			(13, ".(int)$language_id.", 'Prestashop', '&lt;p&gt;Nam varius tempus libero convallis tempus. Etiam odio nunc, vulputate et porttitor quis, tempor vel mi. In luctus, nisl ut placerat placerat, massa metus cursus felis, vitae cursus justo orci nec tellus. Vestibulum id neque in velit hendrerit scelerisque at non nisi. Praesent ultrices risus tempor velit malesuada non pellentesque nulla euismod. Nunc vitae molestie lorem. Integer dapibus tellus vitae augue rutrum eu suscipit nisl adipiscing. Ut at laoreet enim. Sed eu dui dui, id vulputate lacus. Etiam viverra venenatis quam. Morbi ante felis, iaculis ac fermentum sit amet, venenatis sollicitudin libero.&lt;/p&gt;\r\n', 'Nam varius tempus libero convallis tempus', 'Etiam odio nunc, vulputate et porttitor quis, tempor vel mi.'),
			(14, ".(int)$language_id.", 'Zend Cart', '&lt;p&gt;Proin non lacus ipsum. Quisque eleifend nisi dui. Suspendisse ullamcorper elementum dignissim. Mauris porttitor tempus sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque mattis laoreet tortor, vitae laoreet sapien egestas id. Vivamus non leo leo, ut fringilla odio. Praesent mattis fermentum congue. Donec mollis urna non arcu eleifend porta. Vestibulum sit amet tellus neque. Proin id lectus mi. Vivamus non nibh et neque consectetur elementum. Pellentesque fermentum faucibus laoreet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis sit amet tincidunt sem.&lt;/p&gt;\r\n', 'Proin non lacus ipsum.', 'Suspendisse ullamcorper elementum dignissim. '),
			(15, ".(int)$language_id.", 'Jquery Templates', '&lt;p&gt;\r\nPhasellus nibh erat, rutrum eu pretium sit amet, pulvinar in magna. Phasellus interdum, dolor ut convallis hendrerit, arcu elit volutpat ligula, vel tincidunt augue neque eget lectus. Vivamus porttitor, leo id pellentesque pulvinar, dui massa vulputate est, et viverra risus odio ac ante. Ut fringilla laoreet orci. Maecenas fringilla bibendum luctus. Suspendisse dapibus nibh eu nibh accumsan faucibus. Mauris ornare, nunc id tempor adipiscing, lectus sem hendrerit lectus, at condimentum urna ipsum sit amet ligula. Nulla commodo scelerisque porttitor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla ac nisi urna. Vestibulum posuere diam vel diam elementum tempus. Suspendisse potenti.\r\n&lt;/p&gt;', '', ''),
			(16, ".(int)$language_id.", 'Photo Gallery', '&lt;p&gt;\r\nNam condimentum adipiscing nisl id volutpat. Aenean pharetra viverra vehicula. Maecenas aliquet tempus eros, in euismod nisi aliquam a. Suspendisse potenti. Nullam suscipit velit non metus pretium mollis. Nullam quis malesuada turpis. Mauris malesuada lorem id leo accumsan feugiat. Maecenas aliquam tincidunt quam rhoncus pretium. Nulla pharetra accumsan congue. Sed blandit convallis nisl eu ornare. Vivamus commodo massa a orci sagittis consectetur. Nam in libero purus. Sed convallis, felis eget interdum gravida, risus ligula elementum felis, sed porta diam purus vel eros. Suspendisse lacinia euismod ipsum, eget aliquet turpis pharetra ut. Fusce tempor laoreet odio nec consectetur.\r\n&lt;/p&gt;', '', ''),
			(17, ".(int)$language_id.", 'Creative Ideas', '&lt;p&gt;Mauris fringilla accumsan nunc, vitae eleifend metus commodo vitae. Quisque purus metus, blandit non convallis aliquet, porta sed massa. Curabitur ut dolor sagittis diam consequat scelerisque. Duis vel commodo quam. Quisque eleifend facilisis odio vitae rhoncus. Aliquam blandit elementum mollis. Nulla facilisis scelerisque pharetra. Nunc tempor mollis nulla nec gravida. Vestibulum interdum, dui sit amet pretium ultricies, ante nunc sodales dui, ut elementum urna neque non urna. Maecenas posuere pulvinar varius.&lt;/p&gt;\r\n', 'Mauris fringilla accumsan nunc.', 'vitae, eleifend, metus, commodo'),
			(18,".(int)$language_id.", 'Classic Romance', '&lt;p&gt;\r\nVestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Sed mattis varius tortor, a tempus ipsum tempor eget. Donec magna nisi, suscipit ut cursus et, blandit eu dolor. Suspendisse nulla justo, hendrerit non vulputate eu, scelerisque eu massa. Morbi in elit eros. Vivamus ut metus neque, ac fermentum mi. Nam non suscipit justo. Phasellus ornare sollicitudin sollicitudin. Donec tincidunt vestibulum erat non luctus. Sed adipiscing, tortor at congue lacinia, justo tellus adipiscing erat, sit amet semper dolor nunc eget justo.\r\n&lt;/p&gt;', 'Donec magna nisi, suscipit ut cursus et, blandit eu dolor. Suspendisse nulla justo, hendrerit non vulputate eu, scelerisque eu massa.', 'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae.');");			
			$this->db->query("INSERT INTO `".DB_PREFIX."news_download_description` (`download_id`, `language_id`, `name`) VALUES
			(1, ".(int)$language_id.", 'Free Template'),(3, ".(int)$language_id.", 'Romance Album'),(4, ".(int)$language_id.", 'New Catalogue'),(6, ".(int)$language_id.", 'Responsive Image');");			
			$this->db->query("INSERT INTO `".DB_PREFIX."news_article_description` (`article_id`, `language_id`, `name`, `sub_description`,`description`,`meta_description`, `meta_keyword`, `tag`) VALUES (1, ".(int)$language_id.", 'Mustache - Onepage Retina HTML Template','','&lt;p&gt;Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; In hac habitasse platea dictumst. Morbi vel metus vestibulum lacus gravida vestibulum. In id est tellus. Ut lectus nisl, tincidunt et feugiat eu, molestie consequat tortor. Suspendisse vitae erat cursus est vestibulum aliquet. Vestibulum in nunc nisl, quis cursus est. Pellentesque placerat neque et ante rhoncus vulputate. Quisque at libero sapien. Morbi nec elit ut elit ornare congue sit amet ut augue. Nulla suscipit, ante mattis gravida dapibus, est orci vestibulum lorem, in eleifend ante tellus ut felis.&lt;/p&gt;\r\n\r\n&lt;p&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum condimentum euismod faucibus. Integer a diam metus, eget volutpat sem. Nunc feugiat mauris lacinia velit molestie porta. Mauris mollis consectetur nibh eu vestibulum. Duis at malesuada ante. Pellentesque dui diam, rhoncus et imperdiet vel, convallis vel odio. Mauris auctor, sapien eleifend egestas feugiat, sem justo pharetra ligula, eu bibendum velit elit ac elit. Phasellus ut sapien ut lorem porttitor ultrices. Vivamus ipsum risus, tempor nec congue sit amet, aliquam in magna. Etiam nec mollis nisl. Donec id eros eros. Donec odio lorem, dignissim vitae dapibus ut, rutrum elementum mi. Suspendisse rhoncus, est et varius euismod, est tortor imperdiet lacus, vitae viverra neque turpis vel quam. Suspendisse luctus nisi vel est venenatis quis fermentum risus posuere.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/07.jpeg&quot; style=&quot;width: 200px; height: 150px; float: left; margin: 5px;&quot; /&gt;Fusce eu sem sed sem cursus vestibulum ac non quam. Vivamus eu libero ac velit dignissim pellentesque. Fusce tempus turpis sit amet risus scelerisque interdum. Mauris lobortis, tortor in euismod commodo, mi elit blandit turpis, ut rutrum lectus tellus ut sem. Ut vel neque massa. Aliquam mollis nibh mi, nec commodo nulla. Nam sed metus sem, quis faucibus velit. Quisque sagittis rhoncus mi, ut suscipit urna bibendum ut. Fusce congue est suscipit nibh tempus varius. Sed luctus hendrerit metus. Morbi fringilla, urna scelerisque hendrerit euismod, felis tortor venenatis urna, vitae convallis arcu urna vestibulum nisi. Sed id tellus sapien. Vestibulum ac erat eu erat dignissim molestie.&lt;/p&gt;\r\n', '', '', ''),
			(2, ".(int)$language_id.", 'NASH - Responsive HTML5 One Page Theme','','&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/10.png&quot; style=&quot;width: 200px; height: 113px; float: right; margin: 10px 5px;&quot; /&gt;Suspendisse aliquam, nisl at pellentesque rutrum, enim nunc venenatis enim, vitae ornare velit leo sit amet metus. Integer ac libero et diam egestas aliquam eu sed magna. Vestibulum malesuada nulla eget purus consectetur vitae malesuada arcu lobortis. Aliquam aliquet, ligula at laoreet condimentum, magna nisl pretium orci, et fringilla quam sem ut lectus. Vivamus elit est, euismod sed laoreet vel, ullamcorper vel ante. In nec nisi nisi, id tempor quam. Quisque tincidunt vulputate est, sit amet pulvinar mauris fringilla id. Ut eget nisl nec turpis pellentesque porta ac in diam. Praesent ut augue et diam hendrerit iaculis eleifend ac risus. Mauris nulla sapien, sollicitudin sit amet sodales eget, bibendum ut ante. Nullam sit amet lacus malesuada sem dignissim aliquet dapibus id diam. Nulla tempor, est et congue volutpat, quam enim bibendum mi, molestie dignissim tortor ligula nec eros. Curabitur vulputate libero et elit aliquet quis convallis lacus hendrerit. In lorem quam, fermentum id cursus vel, pulvinar eu diam.&lt;/p&gt;\r\n\r\n&lt;p&gt;Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; In hac habitasse platea dictumst. Morbi vel metus vestibulum lacus gravida vestibulum. In id est tellus. Ut lectus nisl, tincidunt et feugiat eu, molestie consequat tortor. Suspendisse vitae erat cursus est vestibulum aliquet. Vestibulum in nunc nisl, quis cursus est. Pellentesque placerat neque et ante rhoncus vulputate. Quisque at libero sapien. Morbi nec elit ut elit ornare congue sit amet ut augue. Nulla suscipit, ante mattis gravida dapibus, est orci vestibulum lorem, in eleifend ante tellus ut felis.&lt;/p&gt;\r\n\r\n&lt;p&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum condimentum euismod faucibus. Integer a diam metus, eget volutpat sem. Nunc feugiat mauris lacinia velit molestie porta. Mauris mollis consectetur nibh eu vestibulum. Duis at malesuada ante. Pellentesque dui diam, rhoncus et imperdiet vel, convallis vel odio. Mauris auctor, sapien eleifend egestas feugiat, sem justo pharetra ligula, eu bibendum velit elit ac elit. Phasellus ut sapien ut lorem porttitor ultrices. Vivamus ipsum risus, tempor nec congue sit amet, aliquam in magna. Etiam nec mollis nisl. Donec id eros eros. Donec odio lorem, dignissim vitae dapibus ut, rutrum elementum mi. Suspendisse rhoncus, est et varius euismod, est tortor imperdiet lacus, vitae viverra neque turpis vel quam. Suspendisse luctus nisi vel est venenatis quis fermentum risus posuere.&lt;/p&gt;\r\n', 'Suspendisse aliquam, nisl at pellentesque rutrum, enim nunc venenatis enim', ' vitae ornare velit leo sit amet metus. Integer ac libero et diam egestas aliquam eu sed magna', ''),
			(3, ".(int)$language_id.", 'Portdesign - Responsive HTML5 Template','', '&lt;p&gt;Phasellus ac purus id neque faucibus gravida. Curabitur quam ante, malesuada et dignissim ac, varius at urna. Cras turpis metus, fermentum nec ornare non, lacinia a felis. Nam mollis, felis eu tempus ornare, purus tellus tristique nibh, cursus scelerisque tellus eros sit amet justo. Donec sed erat vitae justo pharetra ornare.&lt;/p&gt;\r\n\r\n&lt;p&gt;Nullam pretium aliquet viverra. Mauris ante libero, auctor in tempus quis, tristique at magna. Praesent et porta mauris. Aliquam erat volutpat. Ut malesuada, orci a eleifend mollis, lectus ligula scelerisque sem, eget consectetur nibh lectus ullamcorper nunc. Aenean pretium nunc in turpis consectetur sit amet rutrum turpis lobortis. Pellentesque in vulputate justo. Aenean scelerisque tincidunt felis, nec mattis diam hendrerit in. Proin euismod iaculis ante vitae commodo. Suspendisse non quam ut diam adipiscing viverra. Proin auctor varius nunc, a laoreet arcu ultricies et. Cras est ipsum, bibendum in auctor ut, commodo vitae ante. Aliquam viverra molestie consectetur. Donec a neque non ipsum sagittis malesuada. Ut vitae blandit lectus. Suspendisse potenti. Proin malesuada varius auctor. Nam venenatis nisl urna. Vivamus et varius massa. Praesent convallis lobortis ante tincidunt cursus. Praesent libero leo, vulputate at posuere porta, euismod semper odio. In varius, erat vel lobortis rhoncus, quam tellus auctor nulla, ac egestas elit turpis sit amet elit. Aliquam ac erat sed odio commodo posuere.&lt;/p&gt;\r\n\r\n&lt;p&gt;Etiam accumsan faucibus ante, lobortis sodales magna pretium non. Vivamus ornare feugiat semper. Ut scelerisque metus ut nibh dictum vel lacinia mi tristique. Nulla at quam quis felis malesuada consectetur. Phasellus sed eros nibh. Vivamus dapibus, neque vitae pellentesque suscipit, elit sem porta nibh, at pretium nisi ipsum quis diam. Vivamus lobortis lorem ac libero tincidunt molestie. Nam sapien mi, condimentum quis faucibus at, consequat eu libero.&lt;/p&gt;\r\n\r\n&lt;p&gt;Donec sed felis urna, vitae imperdiet nibh. Quisque vel nulla mi. Quisque ut neque massa, a placerat purus. Sed gravida fringilla tellus nec malesuada. Maecenas tempor felis quis dolor euismod a gravida nisi interdum. Phasellus quis mauris at magna semper varius sit amet non tellus. Etiam euismod, justo nec eleifend malesuada, nisl quam lobortis est, sit amet dapibus ligula dui eget risus. Ut ac odio nec dolor vestibulum condimentum id id magna.&lt;/p&gt;\r\n\r\n&lt;p&gt;Sed facilisis elementum dolor nec feugiat. Aenean non nisi felis. Aliquam quis mi eget nisi convallis scelerisque eget eget dui. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Fusce id nisi turpis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n', '', '', ''),
			(4, ".(int)$language_id.", 'Tango - Responsive HTML5 Template','','&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/05.jpg&quot; style=&quot;width: 200px; height: 150px; float: right; margin: 10px 5px;&quot; /&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi porta, tortor a ornare blandit, nulla ligula scelerisque lorem, et dapibus felis mauris ut est. Nulla facilisi. Phasellus ac purus id neque faucibus gravida. Curabitur quam ante, malesuada et dignissim ac, varius at urna. Cras turpis metus, fermentum nec ornare non, lacinia a felis. Nam mollis, felis eu tempus ornare, purus tellus tristique nibh, cursus scelerisque tellus eros sit amet justo. Donec sed erat vitae justo pharetra ornare.&lt;br /&gt;\r\nNullam pretium aliquet viverra. Mauris ante libero, auctor in tempus quis, tristique at magna. Praesent et porta mauris. Aliquam erat volutpat. Ut malesuada, orci a eleifend mollis, lectus ligula scelerisque sem, eget consectetur nibh lectus ullamcorper nunc. Aenean pretium nunc in turpis consectetur sit amet rutrum turpis lobortis. Pellentesque in vulputate justo. Aenean scelerisque tincidunt felis, nec mattis diam hendrerit in. Proin euismod iaculis ante vitae commodo. Suspendisse non quam ut diam adipiscing viverra. Proin auctor varius nunc, a laoreet arcu ultricies et. Cras est ipsum, bibendum in auctor ut, commodo vitae ante. Aliquam viverra molestie consectetur. Donec a neque non ipsum sagittis malesuada. Ut vitae blandit lectus. Suspendisse potenti. Proin malesuada varius auctor. Nam venenatis nisl urna. Vivamus et varius massa. Praesent convallis lobortis ante tincidunt cursus. Praesent libero leo, vulputate at posuere porta, euismod semper odio. In varius, erat vel lobortis rhoncus, quam tellus auctor nulla, ac egestas elit turpis sit amet elit. Aliquam ac erat sed odio commodo posuere.Etiam accumsan faucibus ante, lobortis sodales magna pretium non. Vivamus ornare feugiat semper. Ut scelerisque metus ut nibh dictum vel lacinia mi tristique. Nulla at quam quis felis malesuada consectetur. Phasellus sed eros nibh. Vivamus dapibus, neque vitae pellentesque suscipit, elit sem porta nibh, at pretium nisi ipsum quis diam. Vivamus lobortis lorem ac libero tincidunt molestie. Nam sapien mi, condimentum quis faucibus at, consequat eu libero.&lt;br /&gt;\r\nDonec sed felis urna, vitae imperdiet nibh. Quisque vel nulla mi. Quisque ut neque massa, a placerat purus. Sed gravida fringilla tellus nec malesuada. Maecenas tempor felis quis dolor euismod a gravida nisi interdum. Phasellus quis mauris at magna semper varius sit amet non tellus. Etiam euismod, justo nec eleifend malesuada, nisl quam lobortis est, sit amet dapibus ligula dui eget risus. Ut ac odio nec dolor vestibulum condimentum id id magna. Sed facilisis elementum dolor nec feugiat. Aenean non nisi felis. Aliquam quis mi eget nisi convallis scelerisque eget eget dui. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Fusce id nisi turpis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ', 'Etiam accumsan faucibus ante, lobortis sodales magna pretium non.', ''),
			(15, ".(int)$language_id.", 'Cum Sociis - Natoque penatibus et magnis','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/17_2.jpg&quot; style=&quot;width: 260px; height: 156px; float: left; margin: 10px;&quot; /&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Integer augue libero, pharetra id viverra vitae, facilisis sit amet purus. Nullam justo libero, elementum vel molestie eu, varius eu diam. Praesent libero mauris, interdum id accumsan at, pellentesque eget sem. Suspendisse tempor sem id eros faucibus eget bibendum nulla accumsan. Integer ultrices tincidunt nunc, quis gravida purus adipiscing quis. Duis elementum urna vitae leo sodales sed feugiat neque aliquam. Praesent vehicula consectetur orci, et commodo neque tincidunt non. Donec in orci nisl. Suspendisse potenti. Sed imperdiet orci augue. Phasellus tempor ipsum non arcu lacinia non tincidunt neque convallis.&lt;/p&gt;\r\n\r\n&lt;p&gt;Vestibulum sit amet dui turpis. Phasellus varius mattis porttitor. Vestibulum vehicula dignissim erat, id tristique odio vestibulum non. Cras in nisi ac lectus varius dapibus id sit amet mauris. Ut quam libero, hendrerit eu dictum a, fringilla nec est. Quisque porta nisi non quam rutrum semper. Sed molestie urna varius nibh pretium aliquam. Nam augue metus, mollis a facilisis ac, cursus nec elit. Etiam tortor nisl, malesuada et scelerisque quis, porta non neque. Suspendisse dapibus, orci eget pharetra ornare, magna est sodales ipsum, sit amet eleifend libero felis id est. Etiam sem nisi, volutpat accumsan pretium quis, volutpat id diam. Aenean vitae massa et libero bibendum molestie in lacinia nisi. Nulla facilisi. Curabitur in odio tortor, a consequat lacus. Etiam in ipsum at sem hendrerit consequat in elementum tellus. Aliquam gravida, erat et suscipit posuere, lorem nisi elementum felis, et elementum dui mi condimentum turpis.&lt;/p&gt;\r\n\r\n&lt;p&gt;Duis vel enim sed dolor tristique vulputate ac quis augue. Nunc posuere congue mollis. Fusce imperdiet, ligula congue posuere fermentum, felis metus tempus tortor, eu adipiscing nisi nunc quis velit. Duis vitae sapien eros, id tempus tortor. Maecenas vel felis ipsum, vitae pulvinar leo. Sed consequat, erat imperdiet suscipit ullamcorper, enim erat fermentum dolor, a commodo arcu justo at augue. Aliquam suscipit laoreet porta. Aliquam consectetur malesuada sapien, sit amet porttitor leo convallis nec. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam nec magna quis neque sodales vulputate. Suspendisse potenti. Nunc in risus vitae nisl ultricies faucibus sit amet a justo. Etiam sit amet posuere ipsum. Suspendisse nisi urna, gravida a sodales vitae, fermentum id purus. Nullam eleifend, nunc nec facilisis malesuada, nulla mi fermentum quam, eget tristique metus risus ut ipsum. Vestibulum sit amet tellus odio.&lt;/p&gt;\r\n', '', '', 'lorem'),
			(5, ".(int)$language_id.", 'Paulo Admin Template','', '&lt;p&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum condimentum euismod faucibus. Integer a diam metus, eget volutpat sem. Nunc feugiat mauris lacinia velit molestie porta. Mauris mollis consectetur nibh eu vestibulum. Duis at malesuada ante. Pellentesque dui diam, rhoncus et imperdiet vel, convallis vel odio. Mauris auctor, sapien eleifend egestas feugiat, sem justo pharetra ligula, eu bibendum velit elit ac elit. Phasellus ut sapien ut lorem porttitor ultrices. Vivamus ipsum risus, tempor nec congue sit amet, aliquam in magna. Etiam nec mollis nisl. Donec id eros eros. Donec odio lorem, dignissim vitae dapibus ut, rutrum elementum mi. Suspendisse rhoncus, est et varius euismod, est tortor imperdiet lacus, vitae viverra neque turpis vel quam. Suspendisse luctus nisi vel est venenatis quis fermentum risus posuere.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/13.png&quot; style=&quot;width: 200px; height: 150px; float: left; margin: 10px 5px;&quot; /&gt;Fusce eu sem sed sem cursus vestibulum ac non quam. Vivamus eu libero ac velit dignissim pellentesque. Fusce tempus turpis sit amet risus scelerisque interdum. Mauris lobortis, tortor in euismod commodo, mi elit blandit turpis, ut rutrum lectus tellus ut sem. Ut vel neque massa. Aliquam mollis nibh mi, nec commodo nulla. Nam sed metus sem, quis faucibus velit. Quisque sagittis rhoncus mi, ut suscipit urna bibendum ut. Fusce congue est suscipit nibh tempus varius. Sed luctus hendrerit metus. Morbi fringilla, urna scelerisque hendrerit euismod, felis tortor venenatis urna, vitae convallis arcu urna vestibulum nisi. Sed id tellus sapien. Vestibulum ac erat eu erat dignissim molestie.&lt;/p&gt;\r\n\r\n&lt;p&gt;Pellentesque pharetra enim sed odio luctus eget suscipit mauris condimentum. Curabitur dictum interdum lorem, vel vehicula lorem venenatis ac. Phasellus semper luctus justo a dapibus. Mauris ut risus ligula, ullamcorper aliquam urna. Nulla tempus tristique varius. Quisque fermentum, lacus non tempor aliquet, velit diam tincidunt orci, condimentum convallis turpis nisl sed elit. Integer pretium turpis non libero porttitor tincidunt. Curabitur commodo sapien quis elit commodo egestas.&lt;/p&gt;\r\n', '', '', ''),
			(6, ".(int)$language_id.", 'The Realm - Clean &amp; Modern Admin Template','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/01.png&quot; style=&quot;width: 200px; height: 150px; float: left; margin: 10px 5px;&quot; /&gt;Fusce eu sem sed sem cursus vestibulum ac non quam. Vivamus eu libero ac velit dignissim pellentesque. Fusce tempus turpis sit amet risus scelerisque interdum. Mauris lobortis, tortor in euismod commodo, mi elit blandit turpis, ut rutrum lectus tellus ut sem. Ut vel neque massa. Aliquam mollis nibh mi, nec commodo nulla. Nam sed metus sem, quis faucibus velit. Quisque sagittis rhoncus mi, ut suscipit urna bibendum ut. Fusce congue est suscipit nibh tempus varius. Sed luctus hendrerit metus. Morbi fringilla, urna scelerisque hendrerit euismod, felis tortor venenatis urna, vitae convallis arcu urna vestibulum nisi. Sed id tellus sapien. Vestibulum ac erat eu erat dignissim molestie.&lt;/p&gt;\r\n\r\n&lt;p&gt;Pellentesque pharetra enim sed odio luctus eget suscipit mauris condimentum. Curabitur dictum interdum lorem, vel vehicula lorem venenatis ac. Phasellus semper luctus justo a dapibus. Mauris ut risus ligula, ullamcorper aliquam urna. Nulla tempus tristique varius. Quisque fermentum, lacus non tempor aliquet, velit diam tincidunt orci, condimentum convallis turpis nisl sed elit. Integer pretium turpis non libero porttitor tincidunt. Curabitur commodo sapien quis elit commodo egestas.&lt;/p&gt;\r\n\r\n&lt;p&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nunc tincidunt laoreet tortor sed rutrum. Vivamus ultricies placerat ipsum, et sagittis justo dictum ac. Curabitur eget nibh sit amet velit molestie tincidunt. Maecenas egestas laoreet nulla a ullamcorper. Curabitur vulputate pulvinar nisi id dictum. Nullam malesuada hendrerit sapien ac tempor.&lt;/p&gt;\r\n', '', '', ''),
			(7, ".(int)$language_id.", 'Katniss Premium Admin Template','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/11.jpg&quot; style=&quot;width: 200px; height: 150px; float: right; margin: 5px;&quot; /&gt;​Pellentesque pharetra enim sed odio luctus eget suscipit mauris condimentum. Curabitur dictum interdum lorem, vel vehicula lorem venenatis ac. Phasellus semper luctus justo a dapibus. Mauris ut risus ligula, ullamcorper aliquam urna. Nulla tempus tristique varius. Quisque fermentum, lacus non tempor aliquet, velit diam tincidunt orci, condimentum convallis turpis nisl sed elit. Integer pretium turpis non libero porttitor tincidunt. Curabitur commodo sapien quis elit commodo egestas.&lt;/p&gt;\r\n\r\n&lt;p&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nunc tincidunt laoreet tortor sed rutrum. Vivamus ultricies placerat ipsum, et sagittis justo dictum ac. Curabitur eget nibh sit amet velit molestie tincidunt. Maecenas egestas laoreet nulla a ullamcorper. Curabitur vulputate pulvinar nisi id dictum. Nullam malesuada hendrerit sapien ac tempor.&lt;/p&gt;\r\n\r\n&lt;p&gt;In id metus magna, sit amet aliquet mi. Nam tempor fermentum elementum. Aliquam erat volutpat. Donec posuere convallis enim, a tincidunt tortor ultrices non. Suspendisse nibh sapien, gravida at accumsan ut, tincidunt ut sapien. Praesent ut augue velit, sit amet mollis quam. Quisque fringilla, lectus in pulvinar euismod, tortor lectus fringilla lacus, at sollicitudin mi felis nec quam. Nullam velit velit, hendrerit id ultricies at, molestie vitae justo. Curabitur lacus metus, imperdiet sed congue eu, ornare ac arcu.&lt;/p&gt;\r\n', '', '', ''),
			(8, ".(int)$language_id.", 'Cum sociis natoque','','&lt;p&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nunc tincidunt laoreet tortor sed rutrum. Vivamus ultricies placerat ipsum, et sagittis justo dictum ac. Curabitur eget nibh sit amet velit molestie tincidunt. Maecenas egestas laoreet nulla a ullamcorper. Curabitur vulputate pulvinar nisi id dictum. Nullam malesuada hendrerit sapien ac tempor.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/02_1.jpg&quot; style=&quot;width: 360px; height: 215px; float: left; margin: 10px;&quot; /&gt;In id metus magna, sit amet aliquet mi. Nam tempor fermentum elementum. Aliquam erat volutpat. Donec posuere convallis enim, a tincidunt tortor ultrices non. Suspendisse nibh sapien, gravida at accumsan ut, tincidunt ut sapien. Praesent ut augue velit, sit amet mollis quam. Quisque fringilla, lectus in pulvinar euismod, tortor lectus fringilla lacus, at sollicitudin mi felis nec quam. Nullam velit velit, hendrerit id ultricies at, molestie vitae justo. Curabitur lacus metus, imperdiet sed congue eu, ornare ac arcu.&lt;/p&gt;\r\n\r\n&lt;p&gt;Fusce feugiat convallis lacus a venenatis. Donec ut magna vel magna placerat adipiscing ac sit amet ante. Sed id nulla sapien. Aliquam a eros lacinia lectus volutpat tempus nec in ante. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum bibendum libero et lectus faucibus vehicula. Maecenas nulla purus, tincidunt id commodo quis, congue nec odio.&lt;/p&gt;\r\n', '', '', ''),
			(9, ".(int)$language_id.", 'In id metus magna','', '&lt;p&gt;In id metus magna, sit amet aliquet mi. Nam tempor fermentum elementum. Aliquam erat volutpat. Donec posuere convallis enim, a tincidunt tortor ultrices non. Suspendisse nibh sapien, gravida at accumsan ut, tincidunt ut sapien. Praesent ut augue velit, sit amet mollis quam. Quisque fringilla, lectus in pulvinar euismod, tortor lectus fringilla lacus, at sollicitudin mi felis nec quam. Nullam velit velit, hendrerit id ultricies at, molestie vitae justo. Curabitur lacus metus, imperdiet sed congue eu, ornare ac arcu.&lt;/p&gt;\r\n\r\n&lt;p&gt;Fusce feugiat convallis lacus a venenatis. Donec ut magna vel magna placerat adipiscing ac sit amet ante. Sed id nulla sapien. Aliquam a eros lacinia lectus volutpat tempus nec in ante. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum bibendum libero et lectus faucibus vehicula. Maecenas nulla purus, tincidunt id commodo quis, congue nec odio.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/category/12.jpg&quot; style=&quot;width: 200px; height: 150px; float: left; margin: 10px 5px;&quot; /&gt;​Integer pretium auctor eros id aliquam. Aenean euismod vehicula pulvinar. Phasellus nec feugiat magna. Duis quis metus nisl, sit amet ultrices mi. Vestibulum luctus mattis augue, et lacinia velit molestie sed. Quisque viverra iaculis enim laoreet elementum. Praesent venenatis porta sapien in auctor. Sed non velit turpis, et bibendum ipsum. Integer egestas ligula eu purus iaculis tempus. Praesent tristique enim sed libero consectetur adipiscing. Donec eget fringilla justo. Aenean gravida vehicula velit at tristique. Sed elementum ultrices lectus eu viverra.&lt;/p&gt;\r\n', '', '', ''),
			(10, ".(int)$language_id.", 'Fusce feugiat','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/04.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px 5px; float: left;&quot; /&gt;Fusce feugiat convallis lacus a venenatis. Donec ut magna vel magna placerat adipiscing ac sit amet ante. Sed id nulla sapien. Aliquam a eros lacinia lectus volutpat tempus nec in ante. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum bibendum libero et lectus faucibus vehicula. Maecenas nulla purus, tincidunt id commodo quis, congue nec odio.&lt;/p&gt;\r\n\r\n&lt;p&gt;Integer pretium auctor eros id aliquam. Aenean euismod vehicula pulvinar. Phasellus nec feugiat magna. Duis quis metus nisl, sit amet ultrices mi. Vestibulum luctus mattis augue, et lacinia velit molestie sed. Quisque viverra iaculis enim laoreet elementum. Praesent venenatis porta sapien in auctor. Sed non velit turpis, et bibendum ipsum. Integer egestas ligula eu purus iaculis tempus. Praesent tristique enim sed libero consectetur adipiscing. Donec eget fringilla justo. Aenean gravida vehicula velit at tristique. Sed elementum ultrices lectus eu viverra.&lt;/p&gt;\r\n\r\n&lt;p&gt;Fusce aliquam pharetra sem, quis mattis tellus sollicitudin vel. Ut id sodales magna. Donec fermentum turpis sed mi ornare tristique. Duis non orci vitae massa aliquam mollis a id est. Aliquam id metus mauris, quis bibendum diam. Nulla laoreet, libero quis suscipit ullamcorper, ante turpis hendrerit augue, id ullamcorper nulla nisl ut nibh. Phasellus vulputate orci vitae leo aliquam lacinia consequat metus euismod. Donec rutrum diam eu tortor dictum elementum. Nulla sollicitudin bibendum mauris, non accumsan enim sollicitudin a. Aliquam laoreet viverra sapien vitae fermentum. Etiam a pharetra purus. Mauris nec orci mauris. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n', '', '', ''),
			(11, ".(int)$language_id.", 'Integer pretium auctor eros','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/11_3.jpg&quot; style=&quot;width: 260px; height: 156px; float: right; margin: 10px;&quot; /&gt;Integer pretium auctor eros id aliquam. Aenean euismod vehicula pulvinar. Phasellus nec feugiat magna. Duis quis metus nisl, sit amet ultrices mi. Vestibulum luctus mattis augue, et lacinia velit molestie sed. Quisque viverra iaculis enim laoreet elementum. Praesent venenatis porta sapien in auctor. Sed non velit turpis, et bibendum ipsum. Integer egestas ligula eu purus iaculis tempus. Praesent tristique enim sed libero consectetur adipiscing. Donec eget fringilla justo. Aenean gravida vehicula velit at tristique. Sed elementum ultrices lectus eu viverra.&lt;/p&gt;\r\n\r\n&lt;p&gt;Fusce aliquam pharetra sem, quis mattis tellus sollicitudin vel. Ut id sodales magna. Donec fermentum turpis sed mi ornare tristique. Duis non orci vitae massa aliquam mollis a id est. Aliquam id metus mauris, quis bibendum diam. Nulla laoreet, libero quis suscipit ullamcorper, ante turpis hendrerit augue, id ullamcorper nulla nisl ut nibh. Phasellus vulputate orci vitae leo aliquam lacinia consequat metus euismod. Donec rutrum diam eu tortor dictum elementum. Nulla sollicitudin bibendum mauris, non accumsan enim sollicitudin a. Aliquam laoreet viverra sapien vitae fermentum. Etiam a pharetra purus. Mauris nec orci mauris. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n\r\n&lt;p&gt;Etiam vel ipsum turpis. Pellentesque eget ligula et dolor cursus scelerisque. Aliquam ac massa turpis, sit amet dapibus orci. Duis consectetur arcu semper libero ultrices ac cursus lorem dictum. Sed tristique sem sed massa fermentum imperdiet. Phasellus in velit a purus placerat hendrerit. Cras convallis, sapien at tincidunt blandit, enim metus porta orci, quis congue elit diam at libero. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vestibulum sed lorem nunc, id gravida lectus. Cras turpis dui, luctus vel egestas at, sollicitudin at risus. Sed eget magna odio, vitae dignissim neque.&lt;/p&gt;\r\n', '', '', ''),
			(13, ".(int)$language_id.", 'Etiam - Vvel ipsum turpis','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/17_4.jpg&quot; style=&quot;width: 260px; height: 156px; float: left; margin: 10px;&quot; /&gt;Etiam vel ipsum turpis. Pellentesque eget ligula et dolor cursus scelerisque. Aliquam ac massa turpis, sit amet dapibus orci. Duis consectetur arcu semper libero ultrices ac cursus lorem dictum. Sed tristique sem sed massa fermentum imperdiet. Phasellus in velit a purus placerat hendrerit. Cras convallis, sapien at tincidunt blandit, enim metus porta orci, quis congue elit diam at libero. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vestibulum sed lorem nunc, id gravida lectus. Cras turpis dui, luctus vel egestas at, sollicitudin at risus. Sed eget magna odio, vitae dignissim neque.&lt;/p&gt;\r\n\r\n&lt;p&gt;Ut at nulla dolor. Praesent ullamcorper ullamcorper lectus suscipit sodales. Nunc consequat, urna a rutrum dictum, massa neque ullamcorper urna, non porta justo metus et augue. Duis metus tellus, dignissim nec scelerisque a, dignissim vitae diam. Vivamus posuere, nibh quis bibendum vehicula, lorem arcu imperdiet elit, at porta purus felis eget nibh. Mauris vehicula felis elit, quis aliquet leo. Donec bibendum arcu vitae mi pretium nec rhoncus velit ullamcorper. Duis quis turpis neque. Nam volutpat pellentesque nibh quis molestie. Morbi faucibus enim vitae nisl iaculis vel sagittis tortor ultrices. Cras posuere commodo velit, nec gravida neque mollis ac. Nullam et elementum quam. Nulla dignissim nisl sit amet ligula aliquet pharetra ut nec ligula. Vestibulum sollicitudin, tortor vitae pellentesque fermentum, diam elit mattis ipsum, eget dictum diam arcu et lorem.&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/13_1.jpg&quot; style=&quot;width: 560px; height: 335px; float: right; margin: 10px;&quot; /&gt;​&lt;/p&gt;\r\n\r\n&lt;p&gt;Phasellus nibh erat, rutrum eu pretium sit amet, pulvinar in magna. Phasellus interdum, dolor ut convallis hendrerit, arcu elit volutpat ligula, vel tincidunt augue neque eget lectus. Vivamus porttitor, leo id pellentesque pulvinar, dui massa vulputate est, et viverra risus odio ac ante. Ut fringilla laoreet orci. Maecenas fringilla bibendum luctus. Suspendisse dapibus nibh eu nibh accumsan faucibus. Mauris ornare, nunc id tempor adipiscing, lectus sem hendrerit lectus, at condimentum urna ipsum sit amet ligula. Nulla commodo scelerisque porttitor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla ac nisi urna. Vestibulum posuere diam vel diam elementum tempus. Suspendisse potenti.&lt;/p&gt;\r\n', '', '', ''),
			(14, ".(int)$language_id.", 'Ut at nulla dolor','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/17_3.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px; float: left;&quot; /&gt;Ut at nulla dolor. Praesent ullamcorper ullamcorper lectus suscipit sodales. Nunc consequat, urna a rutrum dictum, massa neque ullamcorper urna, non porta justo metus et augue. Duis metus tellus, dignissim nec scelerisque a, dignissim vitae diam. Vivamus posuere, nibh quis bibendum vehicula, lorem arcu imperdiet elit, at porta purus felis eget nibh. Mauris vehicula felis elit, quis aliquet leo. Donec bibendum arcu vitae mi pretium nec rhoncus velit ullamcorper. Duis quis turpis neque. Nam volutpat pellentesque nibh quis molestie. Morbi faucibus enim vitae nisl iaculis vel sagittis tortor ultrices. Cras posuere commodo velit, nec gravida neque mollis ac. Nullam et elementum quam. Nulla dignissim nisl sit amet ligula aliquet pharetra ut nec ligula. Vestibulum sollicitudin, tortor vitae pellentesque fermentum, diam elit mattis ipsum, eget dictum diam arcu et lorem.&lt;/p&gt;\r\n\r\n&lt;p&gt;Phasellus nibh erat, rutrum eu pretium sit amet, pulvinar in magna. Phasellus interdum, dolor ut convallis hendrerit, arcu elit volutpat ligula, vel tincidunt augue neque eget lectus. Vivamus porttitor, leo id pellentesque pulvinar, dui massa vulputate est, et viverra risus odio ac ante. Ut fringilla laoreet orci. Maecenas fringilla bibendum luctus. Suspendisse dapibus nibh eu nibh accumsan faucibus. Mauris ornare, nunc id tempor adipiscing, lectus sem hendrerit lectus, at condimentum urna ipsum sit amet ligula. Nulla commodo scelerisque porttitor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla ac nisi urna. Vestibulum posuere diam vel diam elementum tempus. Suspendisse potenti.&lt;/p&gt;\r\n\r\n&lt;p&gt;Nam condimentum adipiscing nisl id volutpat. Aenean pharetra viverra vehicula. Maecenas aliquet tempus eros, in euismod nisi aliquam a. Suspendisse potenti. Nullam suscipit velit non metus pretium mollis. Nullam quis malesuada turpis. Mauris malesuada lorem id leo accumsan feugiat. Maecenas aliquam tincidunt quam rhoncus pretium. Nulla pharetra accumsan congue. Sed blandit convallis nisl eu ornare. Vivamus commodo massa a orci sagittis consectetur. Nam in libero purus. Sed convallis, felis eget interdum gravida, risus ligula elementum felis, sed porta diam purus vel eros. Suspendisse lacinia euismod ipsum, eget aliquet turpis pharetra ut. Fusce tempor laoreet odio nec consectetur.&lt;/p&gt;\r\n', '', '', ''),
			(16, ".(int)$language_id.", 'Cras a fringilla tellus','', '&lt;p&gt;Cras a fringilla tellus. Phasellus ac est accumsan justo semper ultrices. Cras quam sapien, cursus a lobortis sit amet, vehicula id dolor. Cras id facilisis dolor. Duis molestie, lorem nec convallis facilisis, diam purus convallis tortor, sed cursus nibh risus sed libero. Fusce ac odio dui, sit amet bibendum turpis. Donec lorem dolor, accumsan ut ornare at, vulputate eu nisl. Donec porttitor eros ut lectus tincidunt vestibulum.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/18_4.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px; float: left;&quot; /&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Integer augue libero, pharetra id viverra vitae, facilisis sit amet purus. Nullam justo libero, elementum vel molestie eu, varius eu diam. Praesent libero mauris, interdum id accumsan at, pellentesque eget sem. Suspendisse tempor sem id eros faucibus eget bibendum nulla accumsan. Integer ultrices tincidunt nunc, quis gravida purus adipiscing quis. Duis elementum urna vitae leo sodales sed feugiat neque aliquam. Praesent vehicula consectetur orci, et commodo neque tincidunt non. Donec in orci nisl. Suspendisse potenti. Sed imperdiet orci augue. Phasellus tempor ipsum non arcu lacinia non tincidunt neque convallis.&lt;/p&gt;\r\n\r\n&lt;p&gt;Vestibulum sit amet dui turpis. Phasellus varius mattis porttitor. Vestibulum vehicula dignissim erat, id tristique odio vestibulum non. Cras in nisi ac lectus varius dapibus id sit amet mauris. Ut quam libero, hendrerit eu dictum a, fringilla nec est. Quisque porta nisi non quam rutrum semper. Sed molestie urna varius nibh pretium aliquam. Nam augue metus, mollis a facilisis ac, cursus nec elit. Etiam tortor nisl, malesuada et scelerisque quis, porta non neque. Suspendisse dapibus, orci eget pharetra ornare, magna est sodales ipsum, sit amet eleifend libero felis id est. Etiam sem nisi, volutpat accumsan pretium quis, volutpat id diam. Aenean vitae massa et libero bibendum molestie in lacinia nisi. Nulla facilisi. Curabitur in odio tortor, a consequat lacus. Etiam in ipsum at sem hendrerit consequat in elementum tellus. Aliquam gravida, erat et suscipit posuere, lorem nisi elementum felis, et elementum dui mi condimentum turpis.&lt;/p&gt;\r\n', '', '', 'nam eu, magna a diam.'),
			(17, ".(int)$language_id.", 'Cras quam sapien','', '&lt;p&gt;In ullamcorper magna a justo facilisis ut ultrices lacus mollis. Duis luctus enim eget ligula interdum placerat. Mauris interdum molestie lacus, feugiat placerat nulla tristique ac. Nulla imperdiet velit in lacus mollis at rutrum justo rutrum. Sed at diam sed metus feugiat dignissim. Nullam imperdiet pellentesque tristique. In ut risus at enim auctor tempor eu eu eros. Vestibulum consequat, nulla vitae malesuada convallis, diam libero sagittis turpis, eget dapibus ante lectus nec nibh. Suspendisse eu pulvinar neque. Donec a placerat elit. Sed quis suscipit justo.&lt;/p&gt;\r\n\r\n&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/14_1.jpg&quot; style=&quot;width: 260px; height: 156px; float: right;&quot; /&gt;Cras a fringilla tellus. Phasellus ac est accumsan justo semper ultrices. Cras quam sapien, cursus a lobortis sit amet, vehicula id dolor. Cras id facilisis dolor. Duis molestie, lorem nec convallis facilisis, diam purus convallis tortor, sed cursus nibh risus sed libero. Fusce ac odio dui, sit amet bibendum turpis. Donec lorem dolor, accumsan ut ornare at, vulputate eu nisl. Donec porttitor eros ut lectus tincidunt vestibulum.&lt;/p&gt;\r\n\r\n&lt;p&gt;Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Integer augue libero, pharetra id viverra vitae, facilisis sit amet purus. Nullam justo libero, elementum vel molestie eu, varius eu diam. Praesent libero mauris, interdum id accumsan at, pellentesque eget sem. Suspendisse tempor sem id eros faucibus eget bibendum nulla accumsan. Integer ultrices tincidunt nunc, quis gravida purus adipiscing quis. Duis elementum urna vitae leo sodales sed feugiat neque aliquam. Praesent vehicula consectetur orci, et commodo neque tincidunt non. Donec in orci nisl. Suspendisse potenti. Sed imperdiet orci augue. Phasellus tempor ipsum non arcu lacinia non tincidunt neque convallis.&lt;/p&gt;\r\n', '', '', 'cras, a fringilla, tellus'),
			(19, ".(int)$language_id.", 'Integer - Vulputate elit in enim tincidunt','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/16.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px; float: right;&quot; /&gt;Integer vulputate elit in enim tincidunt laoreet. Nunc pellentesque condimentum neque in malesuada. Sed magna leo, varius at pellentesque suscipit, ornare id odio. Nullam et massa nisi. Pellentesque eleifend consectetur massa, nec ultricies lectus auctor a. Morbi cursus dui ac lectus viverra ac molestie magna malesuada. Aenean dignissim interdum urna ac semper. Nam consectetur dignissim bibendum. Vivamus pellentesque tempor ligula. Vivamus in libero in elit aliquet commodo. Sed placerat arcu id mauris pulvinar vel commodo metus porttitor. Praesent sodales iaculis nunc, ut porttitor lorem pharetra quis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n\r\n&lt;p&gt;Nullam quis urna sed dui dictum semper. Proin sapien nibh, imperdiet vitae luctus sit amet, condimentum laoreet odio. In laoreet adipiscing scelerisque. Aliquam eu tellus ante, a elementum justo. Aliquam vitae molestie neque. Aenean condimentum tellus id nisl elementum aliquet. Aliquam erat volutpat. Nullam nunc ipsum, dignissim a malesuada tincidunt, eleifend eu nisl. Morbi sodales justo vel ipsum imperdiet malesuada. Aenean sapien est, sollicitudin eu ultrices cursus, ultrices at nulla. Quisque et ante sem, non luctus tortor. Mauris facilisis ipsum bibendum mauris elementum viverra. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla interdum molestie luctus. Nam elit quam, dapibus vitae dapibus at, viverra a sem.&lt;/p&gt;\r\n\r\n&lt;p&gt;In ullamcorper magna a justo facilisis ut ultrices lacus mollis. Duis luctus enim eget ligula interdum placerat. Mauris interdum molestie lacus, feugiat placerat nulla tristique ac. Nulla imperdiet velit in lacus mollis at rutrum justo rutrum. Sed at diam sed metus feugiat dignissim. Nullam imperdiet pellentesque tristique. In ut risus at enim auctor tempor eu eu eros. Vestibulum consequat, nulla vitae malesuada convallis, diam libero sagittis turpis, eget dapibus ante lectus nec nibh. Suspendisse eu pulvinar neque. Donec a placerat elit. Sed quis suscipit justo.&lt;/p&gt;\r\n', 'Nunc pellentesque condimentum neque in malesuada.', 'Proin sapien nibh, imperdiet vitae luctus sit amet, condimentum laoreet odio. ', 'duis, luctus'),
			(18, ".(int)$language_id.", 'Phasellus - Ac est accumsan justo','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/15_3.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px; float: right;&quot; /&gt;Nullam quis urna sed dui dictum semper. Proin sapien nibh, imperdiet vitae luctus sit amet, condimentum laoreet odio. In laoreet adipiscing scelerisque. Aliquam eu tellus ante, a elementum justo. Aliquam vitae molestie neque. Aenean condimentum tellus id nisl elementum aliquet. Aliquam erat volutpat. Nullam nunc ipsum, dignissim a malesuada tincidunt, eleifend eu nisl. Morbi sodales justo vel ipsum imperdiet malesuada. Aenean sapien est, sollicitudin eu ultrices cursus, ultrices at nulla. Quisque et ante sem, non luctus tortor. Mauris facilisis ipsum bibendum mauris elementum viverra. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla interdum molestie luctus. Nam elit quam, dapibus vitae dapibus at, viverra a sem.&lt;/p&gt;\r\n\r\n&lt;p&gt;In ullamcorper magna a justo facilisis ut ultrices lacus mollis. Duis luctus enim eget ligula interdum placerat. Mauris interdum molestie lacus, feugiat placerat nulla tristique ac. Nulla imperdiet velit in lacus mollis at rutrum justo rutrum. Sed at diam sed metus feugiat dignissim. Nullam imperdiet pellentesque tristique. In ut risus at enim auctor tempor eu eu eros. Vestibulum consequat, nulla vitae malesuada convallis, diam libero sagittis turpis, eget dapibus ante lectus nec nibh. Suspendisse eu pulvinar neque. Donec a placerat elit. Sed quis suscipit justo.&lt;/p&gt;\r\n\r\n&lt;p&gt;Cras a fringilla tellus. Phasellus ac est accumsan justo semper ultrices. Cras quam sapien, cursus a lobortis sit amet, vehicula id dolor. Cras id facilisis dolor. Duis molestie, lorem nec convallis facilisis, diam purus convallis tortor, sed cursus nibh risus sed libero. Fusce ac odio dui, sit amet bibendum turpis. Donec lorem dolor, accumsan ut ornare at, vulputate eu nisl. Donec porttitor eros ut lectus tincidunt vestibulum.&lt;/p&gt;\r\n', 'Nullam quis urna sed dui dictum semper', 'Proin sapien nibh, imperdiet vitae luctus sit amet', 'feugiat, nullam '),
			(12, ".(int)$language_id.", 'Fusce - Aliquam pharetra sem','', '&lt;p&gt;&lt;img alt=&quot;&quot; src=&quot;image/data/easy_article/article/15_3.jpg&quot; style=&quot;width: 260px; height: 156px; margin: 10px; float: right;&quot; /&gt;Nullam quis urna sed dui dictum semper. Proin sapien nibh, imperdiet vitae luctus sit amet, condimentum laoreet odio. In laoreet adipiscing scelerisque. Aliquam eu tellus ante, a elementum justo. Aliquam vitae molestie neque. Aenean condimentum tellus id nisl elementum aliquet. Aliquam erat volutpat. Nullam nunc ipsum, dignissim a malesuada tincidunt, eleifend eu nisl. Morbi sodales justo vel ipsum imperdiet malesuada. Aenean sapien est, sollicitudin eu ultrices cursus, ultrices at nulla. Quisque et ante sem, non luctus tortor. Mauris facilisis ipsum bibendum mauris elementum viverra. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla interdum molestie luctus. Nam elit quam, dapibus vitae dapibus at, viverra a sem.&lt;/p&gt;\r\n\r\n&lt;p&gt;In ullamcorper magna a justo facilisis ut ultrices lacus mollis. Duis luctus enim eget ligula interdum placerat. Mauris interdum molestie lacus, feugiat placerat nulla tristique ac. Nulla imperdiet velit in lacus mollis at rutrum justo rutrum. Sed at diam sed metus feugiat dignissim. Nullam imperdiet pellentesque tristique. In ut risus at enim auctor tempor eu eu eros. Vestibulum consequat, nulla vitae malesuada convallis, diam libero sagittis turpis, eget dapibus ante lectus nec nibh. Suspendisse eu pulvinar neque. Donec a placerat elit. Sed quis suscipit justo.&lt;/p&gt;\r\n\r\n&lt;p&gt;Cras a fringilla tellus. Phasellus ac est accumsan justo semper ultrices. Cras quam sapien, cursus a lobortis sit amet, vehicula id dolor. Cras id facilisis dolor. Duis molestie, lorem nec convallis facilisis, diam purus convallis tortor, sed cursus nibh risus sed libero. Fusce ac odio dui, sit amet bibendum turpis. Donec lorem dolor, accumsan ut ornare at, vulputate eu nisl. Donec porttitor eros ut lectus tincidunt vestibulum.&lt;/p&gt;\r\n', 'Nullam quis urna sed dui dictum semper', 'Proin sapien nibh, imperdiet vitae luctus sit amet', 'feugiat, nullam ');");
			
		}
		
			/*sample module settings*/ 		
			$this->db->query("UPDATE  `". DB_PREFIX ."news_article` SET  `approved` =  '1'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_category'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_list'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_by_type'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_author'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_free_download'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_search'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_slideshow'");
			$this->db->query("DELETE FROM `". DB_PREFIX ."setting` WHERE `group` = 'article_shoutbox'");		
		$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_free_download',`key` = 'config_free_download',value = '6,1,3,4'");
	$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_by_type',`key` = 'featured_article',value = 'a:10:{i:0;s:1:\"8\";i:1;s:1:\"7\";i:2;s:1:\"1\";i:3;s:1:\"4\";i:4;s:2:\"16\";i:5;s:1:\"9\";i:6;s:2:\"19\";i:7;s:1:\"2\";i:8;s:1:\"5\";i:9;s:1:\"6\";}',serialized = '1'");
		
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_category',`key` = 'article_category_module',value = 'a:2:{i:0;a:5:{s:9:\"layout_id\";s:1:\"1\";s:9:\"parent_id\";s:1:\"0\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"1\";}i:1;a:5:{s:9:\"layout_id\";s:2:\"12\";s:9:\"parent_id\";s:1:\"0\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"0\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_list',`key` = 'article_list_module',value = 'a:3:{i:0;a:8:{s:9:\"layout_id\";s:1:\"1\";s:9:\"parent_id\";s:1:\"1\";s:14:\"children_limit\";s:1:\"3\";s:5:\"limit\";s:1:\"1\";s:17:\"description_limit\";s:3:\"128\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"1\";}i:1;a:8:{s:9:\"layout_id\";s:1:\"1\";s:9:\"parent_id\";s:2:\"15\";s:14:\"children_limit\";s:1:\"3\";s:5:\"limit\";s:1:\"1\";s:17:\"description_limit\";s:3:\"128\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}i:2;a:8:{s:9:\"layout_id\";s:1:\"1\";s:9:\"parent_id\";s:1:\"8\";s:14:\"children_limit\";s:1:\"3\";s:5:\"limit\";s:1:\"2\";s:17:\"description_limit\";s:3:\"128\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"3\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_by_type',`key` = 'article_by_type_module',value = 'a:5:{i:0;a:9:{s:9:\"layout_id\";s:1:\"1\";s:12:\"article_type\";s:14:\"recent_article\";s:5:\"limit\";s:1:\"2\";s:17:\"description_limit\";s:3:\"128\";s:11:\"image_width\";s:3:\"150\";s:12:\"image_height\";s:3:\"112\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}i:1;a:9:{s:9:\"layout_id\";s:1:\"1\";s:12:\"article_type\";s:16:\"featured_article\";s:5:\"limit\";s:1:\"1\";s:17:\"description_limit\";s:3:\"128\";s:11:\"image_width\";s:3:\"150\";s:12:\"image_height\";s:3:\"112\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}i:2;a:9:{s:9:\"layout_id\";s:2:\"12\";s:12:\"article_type\";s:16:\"featured_article\";s:5:\"limit\";s:1:\"2\";s:17:\"description_limit\";s:3:\"128\";s:11:\"image_width\";s:3:\"150\";s:12:\"image_height\";s:3:\"112\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"3\";}i:3;a:9:{s:9:\"layout_id\";s:2:\"12\";s:12:\"article_type\";s:11:\"most_viewed\";s:5:\"limit\";s:1:\"2\";s:17:\"description_limit\";s:3:\"128\";s:11:\"image_width\";s:3:\"150\";s:12:\"image_height\";s:3:\"112\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"3\";}i:4;a:9:{s:9:\"layout_id\";s:1:\"1\";s:12:\"article_type\";s:11:\"most_viewed\";s:5:\"limit\";s:1:\"1\";s:17:\"description_limit\";s:3:\"255\";s:11:\"image_width\";s:3:\"200\";s:12:\"image_height\";s:3:\"150\";s:8:\"position\";s:14:\"content_bottom\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:2:\"99\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_author',`key` = 'article_author_module',value = 'a:2:{i:0;a:5:{s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:12:\"column_right\";s:5:\"style\";s:8:\"dropdown\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}i:1;a:5:{s:9:\"layout_id\";s:2:\"12\";s:8:\"position\";s:11:\"column_left\";s:5:\"style\";s:8:\"dropdown\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_shoutbox',`key` = 'article_shoutbox_captcha',value = '0'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_shoutbox',`key` = 'article_shoutbox_reload_time',value = '8'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_shoutbox',`key` = 'article_shoutbox_login',value = '0'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_shoutbox',`key` = 'article_shoutbox_module',value = 'a:1:{i:0;a:4:{s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"0\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_free_download',`key` = 'article_free_download_module',value = 'a:2:{i:0;a:4:{s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"9\";}i:1;a:4:{s:9:\"layout_id\";s:2:\"12\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_search',`key` = 'article_search_module',value = 'a:2:{i:0;a:4:{s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"0\";}i:1;a:4:{s:9:\"layout_id\";s:2:\"12\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"0\";}}',serialized = '1'");
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_slideshow',`key` = 'article_slideshow_module',value = 'a:1:{i:0;a:9:{s:9:\"layout_id\";s:1:\"1\";s:12:\"article_type\";s:16:\"featured_article\";s:5:\"limit\";s:2:\"10\";s:17:\"description_limit\";s:2:\"96\";s:11:\"image_width\";s:3:\"320\";s:12:\"image_height\";s:3:\"240\";s:8:\"position\";s:11:\"content_top\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"0\";}}',serialized = '1'");		
			$this->db->query("INSERT INTO `" . DB_PREFIX. "setting` SET `group` = 'article_poll',`key` = 'article_poll_module',value = 'a:3:{i:0;a:5:{s:7:\"poll_id\";s:1:\"1\";s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"1\";}i:1;a:5:{s:7:\"poll_id\";s:1:\"2\";s:9:\"layout_id\";s:1:\"1\";s:8:\"position\";s:12:\"column_right\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"3\";}i:2;a:5:{s:7:\"poll_id\";s:1:\"2\";s:9:\"layout_id\";s:2:\"12\";s:8:\"position\";s:11:\"column_left\";s:6:\"status\";s:1:\"1\";s:10:\"sort_order\";s:1:\"2\";}}',serialized = '1'");			
			/*sample module settings*/ 
	}
}
?>